Originally Posted by SaN-DeeP
weird but i am getting this error:
Code:
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT threadid, title, lastpost, postusername,lastposter,dateline
FROM vb3_thread
WHERE forumid IN(3, 4, 44, 5, 45, 6, 14, 52, 11, 10, 46, 13, 30, 33, 43, 34, 32, 31, 37, 38, 40, 42, 39, 41, 15, 16, 17, 18, 19, 7, 36, 21, 24, 35, 20, 22, 47, 48, 53, 49, 50, 51, 25, 26, 27)
AND thread.open <> 10
AND thread.visible = '1'
ORDER BY lastpost
DESC LIMIT 10
mysql error: Unknown table 'thread' in where clause
mysql error number: 1109
changing few lines make it work:
Code:
$getbeitraege= $DB_site->query("
SELECT threadid, title, lastpost, postusername,lastposter,dateline
FROM " . TABLE_PREFIX . "thread
WHERE forumid IN(" . implode(', ', $forumids) . ")
AND vb3_thread.open <> 10
AND vb3_thread.visible = '1'
ORDER BY lastpost
DESC LIMIT $limit
");
|
More Information