Simple SQL Query - ?

firebird · #1 14-Feb-2005, 08:41

I'm running a query that looks like;

"SELECT `uid` FROM `users` ORDER BY `level`, `votes` DESC LIMIT 0,50"

I want to order the users highest level first, and if same level, the user with more votes above the other with the same level. However, if I run this query, I get exactly the opposite (notice I did use DESC). As a matter of fact, nothing changes when I make it 'ASC'.

What's up?

JdS · #2 16-Feb-2005, 08:52

Try this and see if you notice anything different:

Code:

"SELECT `uid`, `level`, `votes` FROM `users` ORDER BY `level` DESC, `votes` DESC LIMIT 0,50"

firebird · #3 16-Feb-2005, 09:00

That's it! I had tried something similar to that, although I forgot to put a comma in between..

Thanks!

Quote:

Originally Posted by JdS

Try this and see if you notice anything different:

Code:

"SELECT `uid`, `level`, `votes` FROM `users` ORDER BY `level` DESC, `votes` DESC LIMIT 0,50"

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DiscountASP.NET Launches SQL Reporting Services	dasp	Web Hosting Advertisements & Offers	0	19-Oct-2004 18:32
Easy SQL query	jlee	MySQL / PHP Forum	1	22-Jul-2004 08:15
SQL multiple languages query	samtediou	MySQL / PHP Forum	6	23-Jul-2003 14:09
Thanx for the sql query, but there must be a little mistake	norok	MySQL / PHP Forum	13	30-Jun-2003 07:30
Search Engine Positioning 101 and 201 "How To" Tips...	000	Search Engine Optimization Forum	0	29-May-2003 11:34