Im having a problem inserting the following data into a Mysql table, just wondering if any one has any ideas on how to get it to work. When i click the register button nothing at all happens . any one got any ideas.
<?php
$connection = mysql_connect("localhost", "root", "")
or die ("Could not connect to server");
$db = mysql_select_db('customer', $connection) or die('could not connect to DB' .mysql_error());
$query = "INSERT INTO customerdetails (custID, userName, title, password, custFirstName, custLastName, email, address1, address2, address3, country, telephone) VALUES (4,'$u', PASSWORD('$p'),'','$fn', '$ln', '$e','', '', '', '', '')";
?>
<form action="home.php"><fieldset>
<legend>Enter your information in the form below:</legend>
<p><b>First Name:</b> <input type="text" name="custFirstName" size="15" maxlength="15" value="<?php if (isset($POST['custFirstName'])) echo $POST['custFirstName']; ?>" /></p>
<p><b>Last Name:</b> <input type="text" name="custLastName" size="30" maxlength="30" value="<?php if (isset($POST['custLastName'])) echo $POST['custLastName']; ?>" /></p>
<p><b>Email Address:</b> <input type="text" name="email" size="40" maxlength="40" value="<?php if (isset($POST['email'])) echo $POST['email']; ?>" /> </p>
<p><b>User Name:</b> <input type="text" name="userName" size="10" maxlength="20" value="<?php if (isset($POST['userName'])) echo $POST['userName']; ?>" /></p>
<p><b>Password:</b> <input type="password" name="password1" size="20" maxlength="20" /></p>
<p><b>Confirm Password:</b> <input type="password" name="password2" size="20" maxlength="20" /></p>
</fieldset>
<div align="center"><input type="submit" name="submit" value="Register" /></div>
</form>
