Re: [PHP] Simplifying MySql queries

2011-02-14 Thread Simcha Younger
On Sat, 12 Feb 2011 22:40:27 +0200 Andre Polykanine an...@oire.org 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

Re: [PHP] Simplifying MySql queries

2011-02-12 Thread Thijs Lensselink
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`

Re: [PHP] Simplifying MySql queries

2011-02-12 Thread Simon J Welsh
On 13/02/2011, at 9:40 AM, 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`

Re: [PHP] Simplifying MySql queries

2011-02-12 Thread Jim Lucas
On 2/12/2011 12: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