I've done a form post from a previous page. The variables are passing, but not making it into the database... what am I missing? Code below:
track_vars;
if ($HTTP_POST_VARS[ssn] != '' && $HTTP_POST_VARS[last] != '' && $HTTP_POST_VARS[first] != '' && $HTTP_POST_VARS[middle] != ''){
mysql_connect(localhost, webdb, 'computer');
mysql_select_db('classeval');
mysql_query("INSERT INTO instructor (inst_id, lastname, middlename, firstname, date_added) VALUES ('$HTTP_POST_VARS[ssn]','$HTTP_POST_VARS[last]','$HTTP_POST_VARS[middle]','$HTTP_POST_VARS[first]', 'NOW()'");
etc...
track_vars;
if ($HTTP_POST_VARS[ssn] != '' && $HTTP_POST_VARS[last] != '' && $HTTP_POST_VARS[first] != '' && $HTTP_POST_VARS[middle] != ''){
mysql_connect(localhost, webdb, 'computer');
mysql_select_db('classeval');
mysql_query("INSERT INTO instructor (inst_id, lastname, middlename, firstname, date_added) VALUES ('$HTTP_POST_VARS[ssn]','$HTTP_POST_VARS[last]','$HTTP_POST_VARS[middle]','$HTTP_POST_VARS[first]', 'NOW()'");
etc...