Random Select Query
| From: | Peter Allum | Date: | Wed, 07 Nov 2001 13:32:32 +0000 |
| Subject: | Random Select Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14086@lists.php.net to get a copy of this message | ||
Hi there,
I am building a website to run tests for people I have a question bank of
about 1000, split into 10 categories, Every time the test is taken I would
like to randomly select 4 questions from each category.
The site is being built using PHP4 & Mysql running on Apache.
It is really just the query that I run I need help on though.
Thank you in advance for your help.
Regards,
Peter Allum