[RESOLVED] I can't count

[thewalluk]

I created a search script which retrieves data from a table in a database. I want it to count and display the total number of results. For example a search for fruit from table super_products returns the following:

Product || Aisle

Banana 1
Apple 1
Orange 2

I then want it to say Your Search returned 3 products.

I've tried the following but it hasn't worked can anyone tell me what I'm doing wrong.

$Total=count(Product);

Thank you

Andrew

[Mark_P_W]

In the output of your while loop you need to include a variable and set it to increment by one with every record.

All you need to do is add a ++$variable, for example...

while (your fetch row code){

++$count;

echo "the results here";

}

echo "$count records found.";

[thewalluk]

Cheers it works perfectly.

[drtebi]

Can you be a little more specific?
What is the variable "Product", an array like
$product = array('Banana', 'Apple', 'Orange');
?
Or is Product the result of your database query? 'cause then it is a "resource", which is actually a table of the data you queried. If that is so, the easiest way to get get the number of rows from your result query is to do

$Total = mysql_num_rows($result);

And remember, the count function will return the number of elements in an array...

[thewalluk]

I've already sorted the problem. But thanks for trying to help.