[PHP-DB] Random content from MySql DB

2008-08-26 Thread A. Joseph
I`m creating a small application that let users take test online, the user will login and visit the test page, questions and answers are stored in MySql database, i want to display each randomly without repeating. test must to completed between some specific amount of time or else the

RE: [PHP-DB] Random content from MySql DB

2008-08-26 Thread Simcha
If the past questions are 1,2,3,4: Select * from `questions` where id not in (1,2,3,4) order by RAND(); Simcha Younger -Original Message- From: A. Joseph [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 7:38 PM To: php-db@lists.php.net Subject: [PHP-DB] Random content from