Combining 3 queries - what to do with the same variable?

[Erwin]

Hi,

Thanks for helping in advance.

I'm running into trouble combining another 3 queries - 2 of them use the same variables.

PHP Code:


$test = $DB_site->query("
    SELECT forum.title,user.userid,title,threadid,thread.lastpost,lastposter,replycount,views,postuserid,postusername 
    FROM thread 
    LEFT JOIN forum USING (forumid)
    LEFT JOIN user ON thread.lastposter=user.username
    ORDER BY lastpost DESC LIMIT 5
"); 


How do I show the thread title AND the forum title?

I cannot use $test[title] since there are 2 title variables being called... how do I separate each title variable?

Also, is joining these 3 queries valid?

Thanks again for helping...