DNS server is not responding

Question

I have a table structure like this:

ID  Win     Bet    UserID       Date
1   win     1000     1      2014-11-12 19:15:34
2   win     1000     1      2014-11-12 19:15:49
3   loose   1000     1      2014-11-12 19:21:52

and I run a query like this:

SELECT 
    u.Username,
    SUM(b.Bet) AS totalWin,
    b.date,
    b.win
FROM blackjack_history AS b
INNER JOIN users_main AS u ON b.UserID = u.ID
WHERE b.win = 'win' GROUP BY b.UserID ORDER BY totalWin DESC, LIMIT 10

The Probem is when i run this query, it returns the row for ID 1 regarding Date. How do i return the date for ID 2 instead? I have tried using Order By but this does not seem to do the job

Solution 1

The message "DNS server is not responding" already explains it: Both the DNS servers that you have configured are unreachable for some reason.

Try changing your DNS servers – for example, to

• Google Public DNS (8.8.8.8 and 8.8.4.4),
• Level3 (4.2.2.4, 4.2.2.3, 4.2.2.2)
• OpenDNS (208.67.220.220 and 208.67.222.222)

Solution 2

Your ip address is from a local network. That means you can still access your local area network but it does not mean an internet connection exists.

The first thing I notice when my internet connection is down is Windows 7 telling me it couldn't connect to the DNS servers.

Comments

[Keith]

What are the values in your IP configuration?

[Anyname Donotcare]

192.168.0.109 255.255.255.0 -------------------- Preferred DNS serve:213.131.66.138 alternate DNS server:213.131.66.139

[MaQleod]

DNS and your internet connection are very different things. Without DNS you still can access the internet, you just can't resolve web pages. The yellow triangle you describe is an issue on your local network, and probably isn't related to DNS, but something with your IP assignment. Is your addressing DHCP or static? How is your network set up? are you going through a router before going into a modem? If so is the modem PPPOE or is it bridged? If so do you get the same problem when not using your router? Can you ping your default gateway?

[O. Jones]

What result do you want?

[user3790467]

Now it just list all the entries in the database where win = 'win'