hi, ok, today i was working on a script using php and mysql, i wanted to query my database and i wanted the order to be listed in a random format. so this is what i did, in this query i will show you.
$Query = "SELECT * FROM mytable WHERE id=23 ORDER BY RAND()";

as you can see, the query will be sorted randomly