hi all
i'm new to php so not really sure where i'm going wrong. I'm trying to insert information from a form into a database table. its all connecting properly and saying that the data has been inserted properly but all thats been inserted is blanks. can anyone help?
html page
<form name="registration" action="insert.php" method="post">
<div align="center">
<p> </p>
<table width="75%" border="0">
</td></tr><tr> <td height="47"><b><font size="4">Name:</font></b></td><td> <input type="text" name="name"></td></tr>tr> <td height="47"><b><font size="4">Email:</font></b></td><td> <input type="text" name="email"></td></tr></table><p><input type="submit" value="Submit to insert.php"></p></div>
</form>
php code - i left put the connection part
<?PHP
$sql = "INSERT INTO registration (Name, Email)
VALUES ('$name','$email')";
$sql_result = mysql_query($sql,$connection) or die ('Could not insert data');
echo('Data inserted successfully');
mysql_close($connection);
?>
