shopping cart array dump problems

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=188787#188787
----------------------------------------------------------------

If anyone can help with this it would be really handy thanks  :wink: 

Why does the following, dump the array from the Order History, rather than the Shopping Cart ?

############
in checkout_shipping.php ive added :
<?php require(DIR_WS_INCLUDES . 'list.php'); ?>


where catalog/includes/list.php is:
-------------------------------------------
<?php

$index = 0;

$me = $customer_id;
  
$product_info_query = tep_db_query("select products_name from " . TABLE_CUSTOMERS_BASKET . ",orders_products where customers_id = '" . $me . "'");
while ($product_info = tep_db_fetch_array($product_info_query)){  
$this->product_info[$index]= array('prods' => $product_info_query['products_name']);

print ("<BR>p: "); echo $product_info['products_name'];

$index++;
}

?>

-----------------------------------------------------------
I also have this one.. which does use the Shopping Cart:

<?php

 $index = 0;

$me = $customer_id;
  
$product_info_query = tep_db_query("select products_id from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $me . "'");
while ($product_info = tep_db_fetch_array($product_info_query)){  
$this->product_info[$index]= array('prods' => $product_info_query['products_id']);

print ("<BR>p: "); echo $product_info['products_id'];

$index++;

?>

---------------------------------------------------

can anyone help  :?: 
my sql join statements knowledge is not too great :?