PHP mySql error: 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 'WHERE ProductId='x'' at line x
I have create a 'product.php' file that links succesfully to a mySql database. Also, there are 2 other file: an 'add_product.php' file that adds to mySql database through a form; and, a one_product.php file that edit product existing in the database. The add product works; but the edit returns an error after clicking submit button. Error message: 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 'WHERE ProductId='x'' at line x. (the error was not there when I tested how the files work together with 4 columns before I started the actual work yesterday.)
The three files, plus the includ files are attached for reference. Please advise what correction should be done
product.php
add-product.php
one-product.php
common.php
The three files, plus the includ files are attached for reference. Please advise what correction should be done
product.php
add-product.php
one-product.php
common.php
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
see this line:
mysql_query("UPDATE products SET ProductName='$ProductName'
,LastModifiedDateTime='$La
should be:
mysql_query("UPDATE products SET ProductName='$ProductName'
,LastModifiedDateTime='$La
mysql_query("UPDATE products SET ProductName='$ProductName'
,LastModifiedDateTime='$La
should be:
mysql_query("UPDATE products SET ProductName='$ProductName'
,LastModifiedDateTime='$La
also I think ' ' not required for Product Id as it in integer data type
Should be like this
mysql_query("UPDATE products SET ProductName='$ProductName'
,LastModifiedDateTime='$La
Should be like this
mysql_query("UPDATE products SET ProductName='$ProductName'
,LastModifiedDateTime='$La
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you AngelIII, can't believe I struggled 3 hours for a comma! I also have to thank Ray for the recommended query arrangement. It inspired me that a sql querry function page (another .php file)is a neat idea. I'll post a new question about function page as I'm new to that.
ASKER
products.sql