Any Ideas?

I used this query to display all Faq and their categories by category and in position order but I get a warning when I try to run it

$dbQuery="SELECT * FROM FAQs LEFT JOIN FAQCategories ON FAQs.CategoryID=FAQCategories.FAQCID GROUP BY FAQ.CategoryID ORDER BY FAQ.FAQPosition ASC";

Has anyone any ideas what is wrong with it Thanks.

And the warning is ... ?

Norm

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in (line number)

this is the line it points to

while ($faqInfo=mysql_fetch_array($result))

result is:
$result = mysql_query($dbQuery, $db);

Any Idea?

Could it be as simple as the missing s in FAQ.CategoryID, i.e. it should be FAQs.CategoryID (ditto for FAQ.FAQPosition)?

If not, I'm not sure.

Norm

Thanks that was the problem I should of know that but I've been staring at this so long I missed the really obvious mistake.