Loop within the loop?

[zzz]

I have two tables with data, t1 and t2.

t1 contains a general info, such as
1. id
2. projectID
3. items (serialized array)

t2 has descriptions of the items, ids of which are stored in t1.items

As a final result in need to output the details from t1 with descriptions of the items from t2. Not really sure how to tackle this...

Shall I run a loop for t1 then unserialize items turning it into an array and then run a second loop for t2 for those items that are in the array? If yes, how do i do this in MySQL?

[steamPunk]

there's maybe a way of doing it in MySQL but I don't know it

I would have 3 tables

t1 = general project data (with a project_id)
t2 = item description data (with an item_id)
t3 = table linking project_id with item_id

that way you could run a query like

SELECT * FROM t3 LEFT JOIN t2 ON (t3.item_id=t2.item_id) WHERE project_id='$id'

maybe the syntax is a bit off but you get the idea

would that work ?