whats wrong with this query?

[Guy G]

$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:

[Paul M]

I notice you haven't included the table prefix for the two inner joins.

[Guy G]

so?

$article = $DB_site->query_first("SELECT article.*, articlepost.*, articlecategory.options AS categoryoptions FROM " . TABLE_PREFIX . "article AS article INNER JOIN " . TABLE_PREFIX . "articlepost AS articlepost ON(articlepost.postid = article.firstpostid) INNER JOIN " . TABLE_PREFIX . "articlecategory AS articlecategory ON(articlecategory.categoryid = article.categoryid) WHERE article.articleid = $a AND articlepost.type=1");

[sabret00the]

you need to format your code better when asking questions, it's easier to read ;)

$article = $DB_site->query_first("
SELECT article.*, articlepost.*, articlecategory.options AS categoryoptions FROM " . TABLE_PREFIX . "article AS article
INNER JOIN " . TABLE_PREFIX . "articlepost AS articlepost ON(articlepost.postid = article.firstpostid)
INNER JOIN " . TABLE_PREFIX . "articlecategory AS articlecategory ON(articlecategory.categoryid = article.categoryid)
WHERE article.articleid = $a AND articlepost.type=1");i'm check it now

[sabret00the]

fixed version

$article = $DB_site->query_first("
SELECT article.*, articlepost.*, articlecategory.options AS categoryoptions
FROM 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");

[Guy G]

thx for the replies... all worked :D