|
Another MySql question...
Alright, so when my user signs up he inputs some information that gets stored into my table called user_needed. Only about 1/2 of the columns are filled up when they register, and there is another 1/2 that is left blank. Now once the user registers and the session is set, they can go to page edit_profile.php and fill in the extra information that is in my table (information that isn't important enough to make them fill out upon registering). I can't figure out how to insert that information into the same row as all the other information. I thought it would be something like:
$username = $_SESSION['username'];
mysql_query("INSERT INTO user_needed WHERE username='$username'
('location', 'gender', 'website_name') VALUES('$location', '$gender', '$website')") or die(mysql_error());
... needless to say it doesn't work.
|