[PHP-DB] Random question selection in PHP w/ MySQL backend. From: Adam Lundrigan (ceo <email protected>)
Date: 07/31/01

I'm having a bit of trouble creating a random question selector. I'm using PHP 4.0.6 and MySQL 3.23.36 on Windows 98 SE.
I've tried several different solutions, but none work at all.

What i need to do is select 10 questions from a database (db: vpt, table: questions), and make sure that the same question doesn't appear twice. The questions need to appear in a random order each time the script is loaded. It sounds simple enough, but i just can't seem to get it to work.

Any suggestions??

Thanks in advance,
 
-Adam Lundrigan
 CEO, VPU
 http://www.vpu-virtual.com/
 
 ICQ # 73617446
 ceo <email protected>