Form-Database problem

[Anon]

Im sending an HTML form to a process.php file... my code is below

<?
$mysql_user="****";
$mysql_pass="**";
$mysql_host="localhost";
$dbname="******";
mysql_connect($mysql_host, $mysql_user, $mysql_pass);
mysql_select_db($dbname);

mysql_query("INSERT INTO Customer (Customer_ID, First_Name, Last_Name, Email, Meat, State, Experience) VALUES ($First_Name, $Last_Name, $Email, $Meat, $State, $Experience)");

mysql_close;

?>

I dont get an error, i just get a blank page, as i should... but no data has been entered into my database

[zhabala]

The number of columns does not correspond to the number of values. You are inserting into 7 columns but 6 values. If th Customer_ID column is serial ( or autoincrement ) it should not be stated in SQL statement.

Zdenek

[Anon]

you could also change your query to:

mysql_query("INSERT INTO Customer (Customer_ID, First_Name, Last_Name, Email, Meat, State, Experience) VALUES ('$First_Name', '$Last_Name', '$Email', '$Meat', '$State', '$Experience')");

so, use single-quotes (and the corresponding problem)