PHP and MySQL error

**SpottyDog** · 04-23-2007, 08:54 AM

hey guys. would appreiciate some help on this....
I get the error

Code:

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 'desc, price) VALUES ('car', 'dfgdf', 'gdfgd', '45', 'Petrol', 'dfgdfg', '4545')' at line 1

Here is the code from the lines it is on about

PHP Code:


			
mysql_select_db('efesales_vehicles');



$type = $_POST['type'];

$make = $_POST['make'];

$model = $_POST['model'];

$enginesize = $_POST['esize'];

$fuel = $_POST['fuel'];

$desc = $_POST['desc'];

$price = $_POST['price'];



$query = "INSERT INTO vehicles (type, make, model, esize, fuel, desc, price) VALUES ('$type', '$make', '$model', '$enginesize', '$fuel', '$desc', '$price')";

mysql_query($query) or die(mysql_error());

**jito** · 04-23-2007, 10:07 AM

PHP Code:


			
$query = "INSERT INTO vehicles (type, make, model, esize, fuel, desc, price) VALUES....

desc is a mysql keyword, thats why you are getting the error.That's why it's always good practise to use quote (``) with table name and field name.

Your query should be:

PHP Code:


			
$query = "INSERT INTO `vehicles` (`type`, `make`, `model`, `esize`, `fuel`, `desc`, `price`) VALUES....

Happy programming.

**SpottyDog** · 07:25 AM

thanks mate you are a legend.