xiao Posted January 11, 2008 Share Posted January 11, 2008 I have this: $query = "SELECT * FROM jobs WHERE (employer_id='".$rij['id']."' AND complete='0')"; $query = mysql_query($query) or die("Fout in query"); $act_jobs = mysql_num_rows($query); $query = "SELECT * FROM jobs WHERE (employer_id='".$rij['id']."' AND complete='1')"; $query = mysql_query($query) or die("Fout in query"); $afg_jobs = mysql_num_rows($query); The first variable contains the number Active jobs, the second one contains the number of Jobs that are closed. Is there a way to shorten this? And maybe combine everything in 1 query? Quote Link to comment https://forums.phpfreaks.com/topic/85549-combine-queries/ Share on other sites More sharing options...
toplay Posted January 11, 2008 Share Posted January 11, 2008 If the "complete" column can only have a '0' or a '1' value, then this query should return a maximum of two rows that would contain the count: $query = "SELECT count(employer_id) AS total, `complete` FROM jobs WHERE employer_id = '{$rij['id']}' GROUP BY `complete`"; Quote Link to comment https://forums.phpfreaks.com/topic/85549-combine-queries/#findComment-436588 Share on other sites More sharing options...
xiao Posted January 11, 2008 Author Share Posted January 11, 2008 And how do I display those results? Quote Link to comment https://forums.phpfreaks.com/topic/85549-combine-queries/#findComment-436609 Share on other sites More sharing options...
revraz Posted January 11, 2008 Share Posted January 11, 2008 It will return a count as field name total. Quote Link to comment https://forums.phpfreaks.com/topic/85549-combine-queries/#findComment-436615 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.