combine queries

[xiao]

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?

[toplay]

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`";

[xiao]

And how do I display those results?

[revraz]

It will return a count as field name total.