Ok, I have seen a few post with the same issue, everyone else seems to get it to work, but not this guy. if i use this script i get no error, but i also get no new data in my database when i view it with phpmyadmin. When set my vars I get parse errors. Anyone, please help. I will try anything.
<?php
if ("$submit") {
// process form
$db = mysql_connect("localhost", "name_") or die (mysql_error());
mysql_select_db("database_name",$db);
$sql = "INSERT INTO table(first_name,last_name,ghinnumber,handicap) VALUES ('$first_name','$last_name','$ghinnumber','$handicap')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
} else{
// display form
?>
<form method="post" action="<?php echo $PHP_SELF; ?>">
<p>First Name:
<input type=text name="first_name">
Last Name:
<input type=text name="last_name">
</p>
<p>GHIN#:
<input type=text name="ghinnumber">
Handicap:
<input type=text name="handicap">
</p>
<p>City:
<input type=text name="city">
State
<input type=text name="state">
</p>
<p> Phone Number:
<input type=text name="phone_number">
Age:
<input type=text name="age">
</p>
<p>Email Address:
<input type=text name="email_address">
</p>
<p>
<center>
<input type="Submit" name="submit" value="Enter information">
</center>
</p>
</form>
<?php
} // end if
?>
