[SOLVED] Counting rows in an array

[Darkmatter5]

Here's my query code.

$query="SELECT clients.last_name, clients.first_name, clients.company_name, jobs.job_id, jobs.job_number, jobs.job_desc
FROM byrnjobdb.clients
INNER JOIN byrnjobdb.jobs
ON byrnjobdb.clients.client_id = byrnjobdb.jobs.client_id
WHERE byrnjobdb.clients.client_id = $client
ORDER BY jobs.job_number ASC";
$result=mysql_query($query);
$row=mysql_fetch_assoc($result);

 

Now if I run.

$count=count($row);
echo $count;

 

I get 6 which is the number of columns in the array not the number of rows collected. How can I count the number of rows?

[craygo]

$count = mysql_num_rows($result);

 

Ray

[Darkmatter5]

Thanks!