angelopc
Last Activity: Dec 13 '09, 08:17 PM
Joined: Dec 13 '09
Location:
-
Bingo! Thank you, Atli. I never would have known to do that. Worked like a charm! -
MySQL, ORDER BY Multiple, 2nd ARG is ignored.
I'm trying to retrieve some results from a table. I want the results chosen randomly, then sorted by the number of "hits".
Here's the code I'm using:
With this syntax, the results are chosen randomly, but they are not sorted by "hits".Code:<?php $latestQuery = "SELECT * FROM pages ORDER BY RAND(), hits DESC LIMIT 100"; ?>
You can see the results at Insoogle.com (scroll...
No activity results to display
Leave a comment: