User Profile
Collapse
-
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
Show More
Leave a comment: