I need help with a simple test form that I want to be able to enter values and have them inserted into mysql test DB. It seems to be connecting and trying to post but what gets posted to the DB are blank fields each time I run the page. Below are the 2 files that I created. Ones and HTML form and the other is the PHP that it posts to.
below is the test3.php code
<html>
<body>
<?php
mysql_connect("mysql-g19a.mysqldbserver.com","fundsf","******");
mysql_select_db("fundsf");
$query = "INSERT INTO test (first, last)
VALUES ('$_POST[firstn]','$_POST[lastn]')";
mysql_query($query)
?>
</body>
this is the form im using
<html>
<boby>
<table cellpadding=20 border=2><tr><td>Enter data in the fields.</td></tr><tr><td align="center">
<p><b>
</b></p>
Please enter your first name
<form action="test3.php" methode="post">
<input type="text" name="firstn">
<br>and Last Name<br>
<input type="text" name="lastn"><br>
<input type="submit" value="SUBMIT">
</form>
</td>
</tr>
</table>
</body>
</http>
