Re: [PHP] Simplifying MySql queries

2011-02-14 Thread Simcha Younger
On Sat, 12 Feb 2011 22:40:27 +0200 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`Cand

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`WHE

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`CandidateQues

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`CandidateQuestion

[PHP] Simplifying MySql queries

2011-02-12 Thread Andre Polykanine
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=