Hi

I have added the following to my checkout_success.php page:

<?php
$code_link = mysql_connect('localhost', 'username', 'password');
if (!$code_link)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db ('database' , $code_link);
$zv_orders_id = (isset($_SESSION['order_number_created']) && $_SESSION['order_number_created'] >= 1) ? $_SESSION['order_number_created'] : $orders_id;
$code_ordered = mysql_query("SELECT products_id FROM orders_products WHERE orders_products_id ='".$zv_orders_id."'");
while($row = mysql_fetch_array($code_ordered))
{
echo $code_ordered;
echo " | ";
if ($code_ordered == "192")
{
$code_quantity = mysql_query("SELECT products_quantity FROM orders_products WHERE orders_products_id ='".$zv_orders_id."'");
while($row = mysql_fetch_array($code_quantity))
{
echo $code_quantity;
}
}
else
echo " | None orderd";
}
?>


It won't work. I can't get the $code_ordered and $code_quantity to show.

I've taken it down at the moment so my store is functioning again.

Thanks

Glenn