changing PHP num_rows method to SQL COUNT

[paddy_fields]

Hi. I was using the method below to count the rows in a table, but I've since learnt I should be using SQL Count.

 

Old method....

//total number of jobs
if ($result = $db->query("SELECT * FROM jobBoard")) {
$totalJobCount = $result->num_rows;
$result->close();
echo $totalJobCount;
}   

I've now changed this to....

//total number of jobs
if ($result = $db->query("SELECT count(*) AS jobCount FROM jobBoard")) {
$findCount = $result->fetch_assoc();
$totalJobCount = $findCount['jobCount'];
$result->close();
echo $totalJobCount;
}   

Is my new method the best way of doing this? It provides the correct result but I'm new to mysqli and I'm not sure if fetch_assoc() is the right way to go?

 

Thanks.

Pat.

Edited December 5, 2013 by paddyfields

[mac_gyver]

you can shorten -

$findCount = $result->fetch_assoc();
$totalJobCount = $findCount['jobCount'];

to be -

list($totalJobCount) = $result->fetch_row();

 

[paddy_fields]

That's great, thank you.

 

Just to get my head around that... is $result an array with one value? And then list($totalJobCount) assigns that array item to $totalJobCount?

[Barand]

$result->fetch_row() will return an array with 1 item (the count)

[paddy_fields]

Ok thanks, I understand. Good to know!