Not processing results that are the same

[SamusKay]

Sorry I just resolved my thread but I just realised a problem.
Its showing just one of the results so the ordered id's are 1,1,1,1 but it just shows product1 once.

<?php
// Include MySQL class
require_once('../../../shop/shop/cart/inc/mysql.class.php');
// Include database connection
require_once('../../../shop/shop/cart/inc/global.inc.php');
$cart = $row_Orders['ordered'];
if ($cart) {
		$items = explode(',',$cart);
		$contents = array();
		foreach ($items as $item) {
			$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
		}
		foreach ($contents as $id=>$qty) {
			$sql = 'SELECT * FROM products WHERE id = '.$id;
			$result = $db->query($sql);
			$row = $result->fetch();
			extract($row);
			echo $row['name'];
			echo ' , ';
			}}
					?>

[illzz]

So are you saying that

$sql = 'SELECT * FROM products WHERE id = '.$id;

is expected to return more than one row possibly??

If so, then you'll want to include a while loop when fetching your results:

foreach ($contents as $id=>$qty) {
    $sql = 'SELECT * FROM products WHERE id = '.$id;
    $result = $db->query($sql);
    while ($row = $result->fetch()) {
        extract($row);
        echo $row['name'];
        echo ' , ';
    }
}

If I'm wrong in my assumptions, can you elaborate a bit more on the expected results and what's currently happening?