> I have a mysql databse with 4 rows, and each row (row1, > row2, row3, and row4) > contains a sentence. now i want these sentences to appear in > random order:
I've always found mysql's RAND() function to be of use. Specifically: SELECT * FROM MyTable WHERE Some='Condition' ORDER BY RAND() LIMIT 4 CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php