SQL Syntax error

[Turmoil Toad]

When I use the drop down menu for 'Manufacturers' I get the following error:

 

1064 - You have an error in your SQL syntax near 'order by pd.products_name' at line 1

select count(p.products_id) as total order by pd.products_name

[TEP STOP]

 

I'm an SQL newbie, and not very good with PHP! If there's a file you need to see to help diagnose the problem, I'll post it right away.

 

Also, how do I change the heading 'Manufacturers' to read something else? For instance, if I want it to read 'Lame Stuff I'm selling'...how do I do that?

 

This is an installation of osCommerce v2.2ms2 (1.0-36).

[Turmoil Toad]

Another problem I'm having with the site...the 'New Products for <month>' section at the bottom doesn't seem to be populated--are these problems related?

[Turmoil Toad]

Anyone know what's going on here?

 

I've searched these forums without finding anything :(

[♥yesudo]

When I use the drop down menu for 'Manufacturers' I get the following error:

 

1064 - You have an error in your SQL syntax near 'order by pd.products_name' at line 1

select count(p.products_id) as total order by pd.products_name

[TEP STOP]

 

I'm an SQL newbie, and not very good with PHP! If there's a file you need to see to help diagnose the problem, I'll post it right away.

 

Also, how do I change the heading 'Manufacturers' to read something else? For instance, if I want it to read 'Lame Stuff I'm selling'...how do I do that?

 

This is an installation of osCommerce v2.2ms2 (1.0-36).

try:

 

select count(p.products_id) as total order by pd.products_name desc