Programming Forums
User Name Password Register
 

RSS Feed
FORUM INDEX | TODAY'S POSTS | UNANSWERED THREADS | ADVANCED SEARCH

 
 
Thread Tools Display Modes
Prev Previous Post in Thread   Next Post in Thread Next
Old Nov 30th, 2005, 6:00 AM   #1
TCStyle
Programmer
 
Join Date: Jan 2005
Location: Albany, NY
Posts: 43
Rep Power: 0 TCStyle is on a distinguished road
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.
TCStyle is offline   Reply With Quote
 

Bookmarks

« Previous Thread in Forum | Next Thread in Forum »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump




DaniWeb IT Discussion Community
All times are GMT -5. The time now is 9:57 AM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC