JOIN problem

[eluser]Sean Gates[/eluser]
No worries!

I believe what he's asking for is to have multiple columns returned for each order. Here again is what he posted:

Code:

Array
(
    [0] => Array
        (
            [id] => 84
            [order_date] => 2010-01-04 15:07:00
            [order_id] => 84
            [product_id] => 1
            [product_id] => 3
        )

    [1] => Array
        (
            [id] => 85
            [order_date] => 2010-01-07 13:24:02
            [order_id] => 85
            [product_id] => 1
        )

)

Basically, you can't have product_id show up as two columns in a returned result. Only one. So, at some point (easily in PHP) you need to rearrange the array. In @Dyllon's example he does just that - rearranges things to have multiple product IDs be associated with a single order.

@underzen, are we answering your question correctly? Please respond. Thanks!