Re: [PHP] Combine SQL query OT

2002-04-26 Thread php3
Addressed to: Richard Baskett <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from Richard Baskett <[EMAIL PROTECTED]> Fri, 26 Apr 2002 01:47:17 -0700 > > Is there a way I can combine these queries? > > $result = queryDB("SELECT count(ResumeID) FROM Resumes WHERE > typeEmplo

[PHP] Combine SQL query OT

2002-04-26 Thread Richard Baskett
Is there a way I can combine these queries? $result = queryDB("SELECT count(ResumeID) FROM Resumes WHERE typeEmploy='1'"); $numEmp = mysql_result($result,0); $result = queryDB("SELECT count(ResumeID) FROM Resumes WHERE typeContract='1'"); $numCon = mysql_result($result,0); $result = queryDB("SELE