Page 1 of 1

[SOLVED] Randomising the result form a DB query

Posted: Wed Jun 09, 2004 1:19 am
by Calimero
The Problem:
I queried the DB and got back results, but I want them to appear in every new search (with the same keywords) differently (random ordering)
Is this done trough PHP or MySQL.

Thanks Ahead !

Posted: Wed Jun 09, 2004 1:23 am
by Weirdan
add ORDER BY RAND() to your query

THANK YOU !

Posted: Wed Jun 09, 2004 1:34 am
by Calimero
And something in the body :D