got this error Couldn;t execute query

ryandenkie

i have this problem on my php programming i need some help
i wish to add some data to my database
i use the function insert into
variables (....)
and it return this error and does not add to my database
the database i am using is mysql
hope some one can help me thanks
Alex
it urgent

bogu

Mysql INSERT

ryandenkie

can i show you the code so you can point out where is the error
when i enter the informations on my form it pass my information to insert into but it could not execute the query
duno why need help

bogu

But encapsulate your php code between php tags [php]...[/php]

ryandenkie

<head>
<title>Hello!</title>
</head>

<body>
<?php
$host="mysql153.secureserver.net";
$user="carcatalog";
$password="password";
$database = "carcatalog";
$connection = mysql_connect($host,$user,$password)
OR DIE ("Unable to connect to database! Please try again later.");
$db= mysql_select_db("$database",$connection)
or die ("Couldn't connect to database");

$query= "INSERT INTO Car ( Carplate no, Password, Your Name, Your Contact No, Your Email Address, Car Model, Car Registration Date, Engine Capacity, Transmission, Asking Price, Mileage, Fuel Type, Vehicle features, Accessories, Description,COE, COE Expiry Date, OMV,PARF,Number of Owners, Type of Vehicle )
VALUES ('$Carplate no', '$Password', '$Your Name', '$Your Contact No', '$Your Email Address', '$Car Model', '$Car Registration Date', '$Engine Capacity', '$Transmission', '$Asking Price', '$Mileage', '$Fuel Type', '$Vehicle features', '$Accessories', '$Description','$COE', '$COE Expiry Date', '$OMV','$PARF','$Number of Owners', '$Type of Vehicle')";
$result= mysql_query($query)
or die ("Couldn't execute query");

</body>

</html>

the error i get is couldnot execute query

bogu

As I was saying encapsulate your php code between php tags [ php]...[ /php]

Man is not good to have your DB table fields name with spaces, I suggest changed them , anyway u need to encapsulet your fields name between this caracter () like this:[code=php]$query= "INSERT INTO Car (Carplate no,Password,Your Name,Your Contact No`,..........[/code]