Guest Posted September 23, 2006 Posted September 23, 2006 I have been adding products to my catalog and when I went to check them on my live site this is the error message I see (only when I click on the category): 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by pd.products_name' at line 1 select count(p.products_id) as total order by pd.products_name [TEP STOP] For some reason though, it appears fine in my What's New section. Can someone help me please...my entire product catalog is like this...
chooch Posted September 23, 2006 Posted September 23, 2006 Run a search engine query and thousands of pages will tell you what to do Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH
Guest Posted September 23, 2006 Posted September 23, 2006 Run a search engine query and thousands of pages will tell you what to do I have tried and I cannot figure out exactly what to do. Thanks anyways for your advice.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.