getting list of products from last order

[fakeDecoy]

I'm trying to get a list of products ordered on the checkout_success page so I can add some Facebook share buttons for each one. I can do the rest if I can manage to get a list of the products into an array.

I have this in includes/languages/english/html_includes/mytemplate/define_checkout_success.php

$orders_query = "SELECT * FROM " . TABLE_ORDERS . "
                 WHERE customers_id = :customersID
                 ORDER BY date_purchased DESC LIMIT 1";
$orders_query = $db->bindVars($orders_query, ':customersID', $_SESSION['customer_id'], 'integer');
$orders = $db->Execute($orders_query);                 

$orders_id = $orders->fields['orders_id'];
$products_query = "SELECT products_id, products_name
                     FROM " . TABLE_ORDERS_PRODUCTS . "
                     WHERE orders_id = '$orders_id'
                     ORDER BY products_name";     

$products = $db->Execute($products_query);

echo '<pre>';
var_dump($products);
echo '</pre>'; 

I'm getting the below output. It's only returning one product, when the order has two products. Is this the way the db->Execute function works, limiting the results to 1? Is there another way I can get all results?

object(queryFactoryResult)#23 (5) { ["is_cached"]=> bool(false) ["resource"]=> resource(530) of type (mysql result) ["cursor"]=> int(0) ["EOF"]=> bool(false) ["fields"]=> array(2) { ["products_id"]=> string(4) "1994" ["products_name"]=> string(61) "Widget Product Name" } }

[mc12345678]

Yes basically. The normal process from that point is to iterate until $products->EOF is true. I have also seen somewhere that it may be possible (future?) To foreach on $products so that do not have to test for the EOF and do not have to remember to MoveNext() on $products.

[fakeDecoy]

Thanks, I used Movenext and that's the trick.

[mc12345678]

Thanks, I used Movenext and that's the trick.

$products->MoveNext() will give your second product, but hopefully you employed something like:

while(!$products->EOF) {
$products_array[] = $products->fields;
$products->MoveNext();
}

Where $products_array is previously declared as an array.

Then to tell if there are any values stored in the array can simply check the sizeof($products_array) to see if it is >0 which would mean that a value was assigned.

The important thing to note is that in the OP it was indicated that the test was going to only involve two products in the list. Then without further clarification of what was being done/used, someone not too familiar with the code methodology might think that using MoveNext() one time would be sufficient for all cases and that it wouldn't be a problem if only one item was in the order.