Hi,
I have this code for query_read. I want to exclude some forum id from this query_read (below the 2 code), how can I do that? Appreciate your assistance on this. Thanks.
$reply_get = vB::$db->query_read("
SELECT * FROM ".TABLE_PREFIX."thread
WHERE visible=1 AND replycount>0 AND lastpost >= $week
ORDER BY replycount DESC
LIMIT 60");
//Latest post
$post_get = vB::$db->query_read("
SELECT * FROM ".TABLE_PREFIX."post p, ".TABLE_PREFIX."thread th
WHERE th.threadid = p.threadid
ORDER BY p.postid DESC
LIMIT 120");
I have this code for query_read. I want to exclude some forum id from this query_read (below the 2 code), how can I do that? Appreciate your assistance on this. Thanks.
$reply_get = vB::$db->query_read("
SELECT * FROM ".TABLE_PREFIX."thread
WHERE visible=1 AND replycount>0 AND lastpost >= $week
ORDER BY replycount DESC
LIMIT 60");
//Latest post
$post_get = vB::$db->query_read("
SELECT * FROM ".TABLE_PREFIX."post p, ".TABLE_PREFIX."thread th
WHERE th.threadid = p.threadid
ORDER BY p.postid DESC
LIMIT 120");
Comment