Re: Random Select query
| From: | _lallous | Date: | Wed, 07 Nov 2001 14:34:39 +0000 |
| Subject: | Re: Random Select query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-73744@lists.php.net to get a copy of this message | ||
SELECT * FROM TABLE WHERE catid=XXX ORDER BY RAND()
"Peter Allum" <develop@connectu.co.uk> wrote in message
news:20011107132734.46277.qmail@pb1.pair.com...
> 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
>
>
>