trying to send form data to mysql

pope

please can you help me, it comes out as if it has been sent to the database but when i go to the database the information is not there.

<html>

<body>

<?php

if ($submit) {

// process form

$db = mysql_connect("domain","user","password");

mysql_select_db("databasename",$db);

$sql = "INSERT INTO customers (Title,FirstName,lastname,address,street,county,town,code,phone,email,fax,AboutUs,comments) VALUES ('$Title','$FirstName','$lastname','$address','$street','$county','$town','$code','$phone','$email','$fax','$AboutUs','$comments)";

$result = mysql_query($sql);

echo "Welcome to standard finance, we will be sending you your username and password shortly.\n";

} else{

// display form

<form method="post" action="submit.php3"></head><body> Title:<select name="Title"> <option selected name="Title" value="Mr">Mr <option name="Title" value="Dr">Dr <option name="Title" value="Prof.">Prof. <option name="Title" value="Mrs">Mrs <option name="Title" value="Ms">Ms <option name="Title" value="Miss">Miss</select>FirstName: <input type="textbox" name ="firstname" type=text><br><br>LastName:<input type="textbox" name ="lastname" type=text><br><br>Address:e.g house no (like 2)<input type="textbox" name ="address" type=text><br><br>Street:              <input type="textbox" name ="street" type=text><br><br>County:           <input type="textbox" name ="county" type=text><br><br>Town:              <input type="textbox" name ="town" type=text><br><br>Postcode:        <input type="textbox" name ="code" type=text><br><br>Telephone:      <input type="textbox" name ="phone" type=text><br><br>E-mail address:<input type="textbox" name ="email" type=text><br><br>Fax:         <input type="textbox" name ="fax" type=text><br><br><B> How did you hear about us?</B><select name="How Did you Hear About Us?"><option selected name="AboutUs" value="Friends">Friends<option value="Other_Members">Other Members<option value="Tv">Television<option value="Newspapers">Newspapers<option value="Internet">Internet</select><br><br><P><B>Comments:<B><P><TEXTAREA NAME ="comments" rows = 7 cols = 30 WRAP></TEXTAREA><br><br><Input type="submit" name ="submit" value="Send Details">  <Input type="Reset" value ="Reset Details"></form>

<?php

} // end if

</body>

</html>

planetsim

why are you selecting the database twice

mysql_select_db("databasename",$db);

why not
mysql_select_db($db);

Now for the problem. There could be an array of problems. Now the first one. Is there actually a row being made thats blank. If so your values are blank. Do

if(empty(var1) || empty(var2))) etc if they are send that back to the form.
if not its ok to insert new row.

Now in your mysql_query try this.
You have this

$result = mysql_query($sql);

as its inserting $result means nothing.

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

try that now