Combine SQL query OT
| From: | Richard Baskett | Date: | Fri, 26 Apr 2002 08:47:17 +0000 |
| Subject: | Combine SQL query OT | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-94709@lists.php.net to get a copy of this message | ||
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("SELECT count(ResumeID) FROM Resumes WHERE typeTemp='1'");
$numTem = mysql_result($result,0);
Rick
"The greatest trick the devil ever played was convincing the world he didn't
exist." - Unknown