On 02/12/2011 09:40 PM, Andre Polykanine wrote:
> Hi all,
> I'm using in my PHP script the following four MySql queries:
> $q1=mysql_query("SELECT * FROM `CandidateQuestions` WHERE
> `Category`='1' ORDER BY RAND() LIMIT 1");
> $q2=mysql_query("SELECT * FROM `CandidateQuestions` WHERE
> `Category`='2' ORDER BY RAND() LIMIT 1");
> $q3=mysql_query("SELECT * FROM `CandidateQuestions` WHERE
> `Category`='3' ORDER BY RAND() LIMIT 1");
> $q4=mysql_query("SELECT * FROM `CandidateQuestions` WHERE
> `Category`='4' ORDER BY RAND() LIMIT 1");
>
> and here goes the question: is there a way to make these four in one
> so strictly one random question is selected from all of the four
> categories?
> Thanks!
>
You really should ask this on a SQL mailing list. it doesn't have much
to do with PHP.
That said. You could use the IN() statement like this:
SELECT * FROM `CandidateQuestions` WHERE `Category` IN (1, 2, 3) ORDER
BY RAND() LIMIT 1;
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
