how to add featured products

[Guest]

bbcth.com/project

Under featured product how do i add the products i want.... i bought the template and modified it. I go to the admin page -> catalog -> products expected

and i get this error

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 '-20, 20' at line 1

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

 

[TEP STOP]

i kno its an error with the sql but id ont know how to modify it. I dont even know if i am approaching this in the right way....

thanks,

shadi

[usernamenone]

Old code new mysql.

 

We need a php expert to let us know the code to modify to make it mysql 5.+ valid code.

 

 

 

bbcth.com/project

Under featured product how do i add the products i want.... i bought the template and modified it. I go to the admin page -> catalog -> products expected

and i get this error

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 '-20, 20' at line 1

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

 

[TEP STOP]

i kno its an error with the sql but id ont know how to modify it. I dont even know if i am approaching this in the right way....

thanks,

shadi

[Jack_mcs]

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 '-20, 20' at line 1

There is a fix for that error in the latest oscommerce update. Read the update file in it and look for split_page_results. Apply that and your problem will go away.

 

Jack

[Guest]

thank you jack.... problem solved