Simple Help : Check this query

[ARP]

Hello,

Can any one review this query and see what's the error on it ? I don't know why this doesn't work

PHP Code:

$favthreads = $db->query_read("
     SELECT threadid, title, forumid
     FROM " . TABLE_PREFIX . "thread
     WHERE postuserid = 'post.postid' AND forumid NOT IN($mynotin)
     $order
     LIMIT $mylimit
     "); 


Thanks in advance

[Jaxel]

What is 'post.postid'? It sounds looks like you forgot to join the post table into the query.

[NoKSouLz]

Yeah same as above you either have used an incorrect prefix or forgot to include the post table.

[ARP]

OK, Can anyone of you guys edit the Query ? Thanks