whats wrong with this query?
$article = $DB_site->query_first("SELECT article.*, articlepost.*, articlecategory.options AS categoryoptions FROM " . TABLE_PREFIX . "article AS article INNER JOIN articlepost AS articlepost ON(articlepost.postid = article.firstpostid) INNER JOIN articlecategory AS articlecategory ON(articlecategory.categoryid = article.categoryid) WHERE article.articleid = $a AND articlepost.type=1");
do u see anything wrong? the error im getting is that there is no such table 'My_Database_Name_Here.articlepost'
im going nuts :ermm:
|
12-15-2004, 11:57 AM
Hybrid Mode
