HTML form data into MySQL database table

Anon

Hello,
I hope someone can help a new quy with a coding problem. I want to send data from a form to a table.I get my "It works" message but the data is not in the table.
Here is the code I used. The table fields are the same as the VALUE data.
Thanks for any help.
Richard

<?
$dbh=mysql_connect ("localhost","username","password") or die ("Unable to connect!");
mysql_select_db(databasename);
$name1 = "fname";
$name2 = "lname";
$name = "prospect_name";
$email = "email";
$time_zone = "time_zone";
$time = "time";
$day = "day";
$month = "month";
$phone_number = "phone_number";
$result = mysql_query ("INSERT INTO (tablename)(fname,lname,prospect_name,email,time_zone,time,day,month) VALUES ('$name1','$name2','$name','$email','$time_zone','$time','$day','$month','$phone_number')
");
if (!result)
{
echo "It Did'nt work: ", mysql_error();
exit;
}
else
{
print (" It Worked.");
}
?>

Anon

Firstly, the tablename doesn't need ( ) around it,I'm not sure if it does harm. Secondly, count the amount of columns and the amount of data to be inserted. You have 8 columns to be filled, and 9 pieces of data. (the phonenumber). You have to be very precise with SQL.

Have fun,
Andre

Anon

Thanks Andre.
Now I have input into the table but its not the data I entered.It's the same as the field names. I appreciate your help. I have been trying to get this to work for two days.
Richard

slug58

I think what you may be doing wrong is when you are assigning the values to your form variables.

If you have submitted a form the name of the form field is the name of the variable on the action page.

so basically get rid of all of this:

$name1 = "fname";
$name2 = "lname";
$name = "prospect_name";
$email = "email";
$time_zone = "time_zone";
$time = "time";
$day = "day";
$month = "month";
$phone_number = "phone_number";

and then make Andre's fix (as you already have) and it should do what you are asking.

Anon

Thank You, Thank You. It worked.

Richard