pecooou1 Posted December 22, 2014 Share Posted December 22, 2014 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 More sharing options...
Psycho Posted December 22, 2014 Share Posted December 22, 2014 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 Link to comment https://forums.phpfreaks.com/topic/293230-retrieve-data-from-database-question/#findComment-1500349 Share on other sites More sharing options...
Barand Posted December 22, 2014 Share Posted December 22, 2014 Easiest way is <ol> <li>Product</li> ... </ol> Link to comment https://forums.phpfreaks.com/topic/293230-retrieve-data-from-database-question/#findComment-1500350 Share on other sites More sharing options...
pecooou1 Posted December 22, 2014 Author Share Posted December 22, 2014 Tnx Psycho, that helped. Link to comment https://forums.phpfreaks.com/topic/293230-retrieve-data-from-database-question/#findComment-1500361 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.