Using LEFT JOIN with out good results

Hello all!

I’m using LEFT JOIN on a query of mine where I would like to be able to display a BOLD title of a thread in a forum if the user that is logged in has not read the last response to the thread.

Right now, I have this code:

[code=php]
$query = “select * from forums_threads as t1
left join forums_readlist as t2 on t2.threadID=t1.id
where t2.userID = ‘$n[id]’
order by t1.lastpost desc
LIMIT $start_from,10”
[/code]

This code just brings me back every row in the “forums_readlist” but not rows from the “forums_threads” … I’m wondering if I need to configure the table in MySQL in a different way? Do I have to do some kind of “joins” there also to make this work?

Hoping for some help ?

Magnus,
Iceland

Also in #PHP _↴