Hi guys,
I have read a few threads on this but I'm still stuck ! I have an array which is a shopping basket, and it holds details about each item, and a number of items. For example, one users basket may be..
Topside Joint
Cotswold Edge
beef
9
1
Pork
Cotswold Edge
sausages
6.00
1
which is the output as...
$name = $_SESSION['basket'][$key]['name'];
$supplier = $_SESSION['basket'][$key]['supplier'];
$category = $_SESSION['basket'][$key]['category'];
$price = $_SESSION['basket'][$key]['price'];
$qty = $_SESSION['basket'][$key]['qty'];
echo $id . "<br />";
echo $name . "<br />";
echo $supplier . "<br />";
echo $category . "<br />";
echo $price . "<br />";
echo $qty . "<br />";
I KNOW this is a bad method (and it doesn't even work!) but this is how my code currently stands:
foreach($_SESSION['basket'] as $key => $another)
{
$name = $_SESSION['basket'][$key]['name'];
$supplier = $_SESSION['basket'][$key]['supplier'];
$category = $_SESSION['basket'][$key]['category'];
$price = $_SESSION['basket'][$key]['price'];
$qty = $_SESSION['basket'][$key]['qty'];
$sql = "INSERT INTO orders VALUES(0,'".$id."','".$oid."','".$name."','".$pric e."','".$supplier."','".$category."')"
$result = mysql_query($sql, $connection)
or die("MySQL Error: ".mysql_error());
}
How can I do this in a way thats a) better/more efficient and b) just works?
Thanks in advance
Dave
