Selecting Rows With Same Column

[paul41598]

How would it work if I needed to select 2 rows with the same column name? For instance:

PHP Code:

$getthreads = $db->query_read("
    SELECT forum.forumid, forum.title, thread.*
    FROM ".TABLE_PREFIX."thread AS thread
    LEFT JOIN ".TABLE_PREFIX."forum AS forum ON(thread.forumid = forum.forumid)
    ");


while($thread = $db->fetch_array($getthreads))
{

$forum['title'] = $thread['title'];

$thread['title'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['title']), 22));

} 


$forum[title] when used in a template will grab the thread title, and not the forum title.

How can I distinguish between the two if possible?



n/m gotta use aliases