JOIN problem

[eluser]Sean Gates[/eluser]
@Dyllon has the right answer (@noctrum, you did great, too). Although I would modify this part of the code a little:

Code:

$orders = array();
foreach($query_result as $order)
{
    $orders[$order['id']][] = $order['product_id'];
}
print_r($orders);

You want to keep things short and sweet.

@wowdesign: From his first post it is clear that your join suggestions will not accomplish what he's looking for.