I'm making a signup form. I have an html page that has all the form boxes and such. when i submit it it goes to the code below. It puts out the html just fine but it doesn't insert anything into mysql. No errors either.
here is the code:
<?php
$username="**";
$password="**";
$database="members";
$first=$POST['first'];
$last=$POST['last'];
$address=$POST['address'];
$box=$POST['box'];
$phone=$POST['phone'];
$email=$POST['email'];
$aim=$POST['aim'];
$major=$POST['major'];
$grad=$POST['grad'];
$hear=$POST['hear'];
$gymbuddies=$POST['gymbuddies'];
$fitchallenge=$POST['fitchallenge'];
$gymrewards=$POST['gymrewards'];
$uptildawn=$POST['uptildawn'];
$intrests=$_POST['intrests'];
mysql_connect("localhost","$username","$password");
@mysql_select_db($database) or die("unable to select database");
$query = "INSERT INTO submissions (first,last,address,box,phone,email,aim,major,grad,hear,gymbuddies,fitchallenge,gymrewards,uptildawn,intrests) VALUES ('$first','$last','$address','$box','$phone','$email','$aim','$major','$grad','$hear','$gymbuddies','$fitchallenge','$gymrewards','$uptildawn')";
mysql_query($query);
mysql_close();
?>
<html>
<head>
<title>Your Information Has Been Submitted - Thank You</title>
</head>
<body>
Info submitted
</body>
</html>
