[SOLVED] Combining queries

[xiao]

Is it possible to get this into 1 query?

$query = "SELECT * FROM jobs WHERE werkgever_id='".$rij['id']."'";
$query = mysql_query($query) or die("Fout in query");
$tot_jobs = mysql_num_rows($query);
$query = "SELECT * FROM jobs WHERE (werkgever_id='".$rij['id']."' AND status='1')";
$query = mysql_query($query) or die("Fout in query");
$act_jobs = mysql_num_rows($query);
$query = "SELECT * FROM jobs WHERE (werkgever_id='".$rij['id']."' AND status='2')";
$query = mysql_query($query) or die("Fout in query");
$afg_jobs = mysql_num_rows($query);
$query = "SELECT * FROM jobs WHERE (werkgever_id='".$rij['id']."' AND status='0')";
$query = mysql_query($query) or die("Fout in query");
$te_valideren = mysql_num_rows($query);

 

And could you maybe also explain what PHP code I need to use to display the 4 variables? Because I'm not really familiar with AS and GROUP BY etc.

 

Thank you

[revraz]

Something like this, just change the mysql_num_rows variable to go with $statusid.  Also, you should probably use COUNT instead, since it seems you just care about how many rows return.

 

$statusid = 1

$query =  "SELECT * FROM jobs WHERE (werkgever_id='".$rij['id']."' AND status='$statusid')";

$query = mysql_query($query) or die("Fout in query");

$act_jobs = mysql_num_rows($query);

 

[xiao]

I currently have this, which makes sence I think:

$query = "SELECT count(werkgever_id) AS tot_jobs, status FROM jobs WHERE werkgever_id = '{$rij['id']}' GROUP BY status";
$query = mysql_query($query);
$rij = mysql_fetch_array($query);

 

But I don't know how to display the results seperately in PHP, without using a while loop.

[revraz]

You mean from here?

 

$rij = mysql_fetch_array($query);

 

You have to use a while ($rij) loop if you want to go through each array.

[xiao]

Isn't there a way to do this without using a while loop?

Because I need to use them at different places around the page.

[xiao]

bump

[xiao]

^

[fenway]

Isn't there a way to do this without using a while loop?

Because I need to use them at different places around the page.

I have no idea what this means... obviously, you have to iterate through the records st!

[rhodesa]

You can load them all into an array (using a while loop). Then get the entries from the array throughout your page.

[xander85]

Once you performed your query and you don't want to use the entire array at once, simply use something like this:

 

$rij['0'], $rij['1'], etc.....

 

Since you are fetching as an array you don't even need to use a while loop to actually construct the array, it is done by php.

[xiao]

Yea, that's what I thought and wanted to know, thank you.