How can i do this? Combined SQL searches

[gte806e]

ok i'm pulling from one table

all tasks that belongs to user_id = 1;

I take that result which is a long list.

Now I want to pull all data for every task id that was gatherd from query 1 and store that into an associtive array.

Is there a way to merge these two searches without using some sort of while($row = mysql_fetch_array(firstQuery))
do this stuff on second query?

Thanks,

Jesse

[Sxooter]

Normally, some kind of join:

select *
from users u
join details d
on (u.id=d.uid)
where u.id=1;

[gte806e]

figured it out thanks!