Jump to content

Retrieve data from database question?


pecooou1

Recommended Posts

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..

Link to comment
https://forums.phpfreaks.com/topic/293230-retrieve-data-from-database-question/
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.