When I use the form below to try and update my mysql database it goes to the confirmation page just fine with no apparent errors but no data gets put into the database.
Any suggestions or help would be greatly appreciated.
<html>
<body>
<?php
$db = mysql_connect("localhost", "root", "my_password"
;
mysql_select_db("mydb",$db);
$sql = "INSERT INTO employees (First_Name, Last_Name, How_Many, Children) VALUES
('$First_Name','$Last_Name','$How_many','$Children')";
?>
<form method="post" action="done.php">
First name:<input type="Text" name="First_Name"><br>
Last name:<input type="Text" name="Last_Name"><br>
How Many:<input type="Text" name="How_Many"><br>
Children:<input type="Text" name="Children"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
</body>
</html>
Any suggestions or help would be greatly appreciated.
<html>
<body>
<?php
$db = mysql_connect("localhost", "root", "my_password"
;mysql_select_db("mydb",$db);
$sql = "INSERT INTO employees (First_Name, Last_Name, How_Many, Children) VALUES
('$First_Name','$Last_Name','$How_many','$Children')";
?>
<form method="post" action="done.php">
First name:<input type="Text" name="First_Name"><br>
Last name:<input type="Text" name="Last_Name"><br>
How Many:<input type="Text" name="How_Many"><br>
Children:<input type="Text" name="Children"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
</body>
</html>