Counting rows and displaying row number

[richrock]

Okay, this is probably a: dead easy and b: not using COUNT(*).

 

I am displaying the results of a search, where a client is searched for, and all items owned/sold by that client are displayed in a table.  However, I need to count and display each result as:

 

1.  Product one

2.  Product two

etc...

 

I can't use ID as there are gaps inbetween each result (this is filtering 900+ items down to about 3 or 4.

 

So how do I get PHP to return each row as 1,2,3,4,5,6,7,etc...

 

All the searches give me details of how to count total rows in mysql (SELECT COUNT(*) FROM table;)

 

Rich

 

[JonnoTheDev]

Set a loop counter when displaying the results.

This is an example - fit into your own loop.

 

$results = array('product 1', 'product 2', 'product 3');
$itemNum = 1;

foreach($results as $product) {
print $itemNum.". ".$product."<br />";
$itemNum++;
}