[mtha]

I want to do the following two thing:


1- Select all posts (with its information) belong to one thread
something like:

PHP Code:

$threadid == X;

$posts = $DB_site->query("
                    SELECT post.*, post.userid FROM post WHERE (post.threadid = $threadid)
");

$post = $DB_site->fetch_array($posts) 


giving me a list of posts, says 15 posts (15 rows)


2. For each posts (each row), there is one userid, I need to select all awards that belong to that userid
something like

PHP Code:

$alluserawards =  $DB_site->query("
                    SELECT award.* FROM award WHERE userid=$post[userid]
"); 


giving me a list of awards, says 5 awards (5 rows)

if I run query #2 for each of the rows, it will run 15 times, + 1 query for #1,

is there any way to optimize the queries? so that I can somehow get a list of awards for each userid.