[SOLVED] Order by a second variable

[raku]

Hey,

 

Is there a way to order by a second variable if the first variable is equal for two rows? For example, if I'm trying to output a list of posts in the order of most comments, but two of the posts have the same number of comments, I'd like the post with the higher view count to be listed first.

 

Thanks.

[AndyB]

... order by comments, views desc ... ought to do it

[blirette]

SELECT * FROM table ORDER BY number_comments, view_count

 

I think GROUP BY could help...but maybe not. Depends on how your DB is setup.

 

Good luck!

[raku]

Thanks for the help guys! I had to do something like this:

 

SELECT * FROM table ORDER BY number_comments DESC, view_count DESC

 

It didn't seem to work without the DESC in there.