Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help anyone ,


APPRENTICE WEBM

Recommended Posts

hi i am getting this error when i am trying to view items in my admin side can anyone help .

 

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 'p, products_description pd where p.products_id = pd.products_id and p.products_i' at line 1

 

select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image,p.products_retail_price, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id fromproducts p, products_description pd where p.products_id = pd.products_id and p.products_id = '29'

 

i will be waiting for your reply

Link to comment
Share on other sites

hi i am getting this error when i am trying to view items in my admin side can anyone help .

064 - 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 'p, products_description pd where p.products_id = pd.products_id and p.products_i' at line 1

 

You have a syntax error - you're missing a space. Change your statement where I have highlighted in bold :

 

select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image,p.products_retail_price, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '29'

 

You were/are mssing the space between 'from' and 'products'

 

david

Link to comment
Share on other sites

thx for your help but can you tell me where to look , do i have to look in the php code or into the database . thx i will be waiting for your reply or to a rply from anyone that cam help me thx once again

 

This statement is in a PHP file in your admin/ directory (or sub-directory).

You would need to post specifically what file or area wihtin your admin side that you clicked on to get this error.

Just post filename from the URL.

 

david

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...