Faracus Posted March 10, 2009 Share Posted March 10, 2009 I am having a small issue. when using the code below it is not creating the username in the MySQL database, but the password part is going in. $sql="INSERT INTO admins (Username, Password)VALUES('$_POST[username]','$_POST[password]')";if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); }echo "Your account has been created."; Link to comment Share on other sites More sharing options...
justsomeguy Posted March 10, 2009 Share Posted March 10, 2009 I would put money on the fact that $_POST['username'] has nothing in it. Link to comment Share on other sites More sharing options...
Faracus Posted March 10, 2009 Author Share Posted March 10, 2009 stupid = got in the code. Now sure how come i missed it. Link to comment Share on other sites More sharing options...
justsomeguy Posted March 10, 2009 Share Posted March 10, 2009 Did you print out $_POST['username'] to see what's actually there, or did you print the SQL query? If the password is being inserted then the query is working. If there's no value for the username, then $_POST['username'] is empty. Check your field names in the form. Link to comment Share on other sites More sharing options...
frisiandi Posted March 24, 2009 Share Posted March 24, 2009 Did you print out $_POST['username'] to see what's actually there, or did you print the SQL query? If the password is being inserted then the query is working. If there's no value for the username, then $_POST['username'] is empty. Check your field names in the form. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.