Re: I went through the whole thread and saw the problem listed

This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=228908#228908
----------------------------------------------------------------

[quote="clarocque"]I, like may others am gettinthe following error
[code]1064 - You have an error in your SQL syntax near 'select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk' at line 1

select count(select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk_date_added, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short from faqdesk_description pd, faqdesk p, faqdesk_to_categories p2c where p.faqdesk_status = \'1\' and p.faqdesk_id = p2c.faqdesk_id and pd.faqdesk_id = p2c.faqdesk_id and pd.language_id = \'1\' and p2c.categories_id = \'2\' order by pd.faqdesk_question) as total 

[TEP STOP]
[/code]

I saw the problem listed but no fix (atleast not what I saw)  Any help for this????

Chris[/quote]

I'm not sure that this is your problem, but on the inner query, you do not need the order by clause.