Retrieve data from database question?

[pecooou1]

I have code for displaying result from database:

foreach ($_SESSION["products"] as $cart_itm)
        {
           $product_code = $cart_itm["code"];
		   $results = $mysqli->query("SELECT * FROM products WHERE product_code='$product_code' LIMIT 1");
		   $obj = $results->fetch_object(); 

Now, I display data with: $obj->product_name

 

 

When I get the list, how to put inline numbers (1 2 3 4 ...)?

 

1       products1

2       products1

3       products1

4       products1..

[Psycho]

Well, you have problems with that current code, but that aside

 

 

$lineNo = 0;
foreach ($_SESSION["products"] as $cart_itm)
{
    $product_code = $cart_itm["code"];
    $results = $mysqli->query("SELECT * FROM products WHERE product_code='$product_code' LIMIT 1");
    $obj = $results->fetch_object();
    $lineNo++;
     echo "{$lineNo} {$obj->product_name}<br>\n";

 

Or, you could put the output into an ordered list

[Barand]

Easiest way is

<ol>
    <li>Product</li>
    ...
</ol>

[pecooou1]

Tnx Psycho, that helped.