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...

[Admin]

You give the fields aliases (a MySQL term), like so:

$test = $DB_site->query("
    SELECT [high]forum.title AS forumtitle[/high],user.userid,[high]thread.title AS threadtitle[/high],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
");

And then use $row[forumtitle] and $row[threadtitle].

[Erwin]

Firefly, thanks again for help. You are very gracious. It works fine.

[Admin]

You're welcome.