SELECT FOUND_ROWS() Question

[rvr1]

I have the following query:

$sql = "SELECT product_name FROM products,product_brand_category WHERE products.product_id = product_brand_category.product_id AND brand_id='9' AND category_id='5'";

$result = mysql_query($sql)
or die ("Could not execute query" . mysql_error());

while ($row = mysql_fetch_array($result))
{
extract($row);
echo"$product_name";
}

What I would like to do is have some way of finding out how many rows match the search criteria and being able to assign this value to a variable, but without having to actually process every row.

I think it can be done with SELECT FOUND_ROWS(), however am not sure how. Can anyone five me some pointers please?

Thanks!

 

[cLFlaVA]

This is a PHP question--

[tt]
$result = mysql_query($sql)
or die ("Could not execute query" . mysql_error());

$num_rows = mysql_num_rows($result);
[/tt]

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!