hey guys. would appreiciate some help on this....
I get the 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 '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()); 


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.

thanks mate you are a legend.