Nothing to do with PHP... SELECT * FROM table ORDER BY RAND();
---John Holmes... > -----Original Message----- > From: Jule [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 12, 2002 9:49 AM > To: [EMAIL PROTECTED] > Subject: [PHP] random order > > Hey guys and gals, > I have a problem: > 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: > instance: 1 2 etc. > row2 row4 > row4 row2 > row1 row1 > row3 row3 > > how do i go about that?? > any ideas apreciated. > thanks > > Jule > -- > |\/\__________________________/\/| > | Jule Slootbeek | > | [EMAIL PROTECTED] | > | http://blindtheory.cjb.net | > | __________________________ | > |/\/ \/\| > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
