Random question selection in PHP w/ MySQL backend.
| From: | Adam Lundrigan | Date: | Tue, 31 Jul 2001 20:32:31 +0000 |
| Subject: | Random question selection in PHP w/ MySQL backend. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10935@lists.php.net to get a copy of this message | ||
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@vpu-virtual.com