DataMapper ORM v1.8.2

[eluser]Carmichael[/eluser]
[quote author="WanWizard" date="1345135286"]@Carmichael,

I still haven't got a good idea what you exactly want, as there is nothing wrong with Maglok's examples.

I've been reading your posts back, and noticed you mention your join table having a 'value' (singular), and then you talk about attributes (plural). Perhaps you should tell us what the table schema is, what exactly is in there, and what you want to get out.

You can only have one join record for any given combination of parents, so if you have multiple attributes, they have to be columns in the join table.

join fields are included in the result with a 'join_' prefix, so if you iterate over $products, you need to access $product->join_fieldname to access fieldname from your join table.[/quote]
I have three tables.

products

Code:

id|name|description|price|image

attributes

Code:

id|name

product_attributes

Code:

product_id|attribute_id|value

Let's fill the tables with som values...

products

Code:

1|iPhone 4s           |NULL|0.00|NULL
2|iPad 2              |NULL|0.00|NULL
3|Samsung Galaxy S III|NULL|0.00|NULL

attributes

Code:

1|memory
2|megapixel
3|os
4|weight

product_attributes

Code:

1|1|16777216
1|2|8
1|3|ios
1|4|140
2|1|16777216
2|3|iOS
2|4|601
3|1|16777216
3|2|8
3|3|android
3|4|133

Now. I want to retrieve all attributes of a product in product_attributes + attribute data from attributes.