mysql or php

[__berfuzz]

I have a table called result, this table has a column called product. Furthermore theres a table JOINing the result-table in this example called extra_result. What I like to do is as follows:

product from result is going to have add ons i a HTML presentation. What I need to do is adding extra to products. the index to add on1, add on2
HTML presentation
client | product + add_on1 + add_on2 etc | etc

The tables in the data bas is:
result
ID | client | product_id | etc

product
product_id | product

result_extra
extra_ID | extra_id if theres a match extra_ID with result.ID extra is to be fetched.

extra
extra_id | extra

Is it possible to do this with mysql or do I have to muster some phpcode to do it. If it's possible, how would that query look?

[leatherback]

Couldn't you just use a join? Say, a left join and verify that there are non-NULL values in the extra.record set?

[__berfuzz]

But how do I add add ons if theres more than one?

LEFT JOIN works for:
HTML presentation
Client1 | Product1 |
Client1 | Product2 | extra1
Client1 | Product2 | extra2

Not for
Client1 | Product2 + extra1 |
Client1 | Product2 + extra1 + extra2 |
etc

OR!?

[leatherback]

I suppose you could keep track of the current client & product and store that in a variable. Add the extra items/info sections in an array, and implode the array when a nuew user/product combvo starts, and output the dataset.