help anyone ,

[APPRENTICE WEBM]

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

[APPRENTICE WEBM]

hello can someone help me please

[davidinottawa]

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

[APPRENTICE WEBM]

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

[davidinottawa]

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