count issue

[dhimok]

How to get total count from this function. I am having problems to get the right count when I am on a parent category

 

<?php
function get_items($id) {
$result = dbQuery("
SELECT * FROM items 
WHERE category_id = '{$id}'
ORDER BY price ASC
LIMIT $offset, $rowsPerPage
");

while($row = mysql_fetch_object($result)) {
	$products[] = $row;
}

$result = mysql_query("SELECT category_id FROM cats WHERE parent_id = {$id}");
    	while ($row = mysql_fetch_assoc($result)) {
		get_items($row["category_id"]);
  		} 
}
}
?>

 

thanks

[darkfreaks]

<?php 

$row_count = mysql_num_rows($result); 

echo count($products); ?>