Go Back   Cloud Computing > Support > MySQL Issues.
 

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 08-05-11, 04:40
BOD Member
 
Join Date: Aug 2011
Posts: 76
Default Add info from 2 separate forms

Hi
can I get some advice on whether this is workable, or even best practice.

I have a database with a login and registration script. It records basic info like name, username and password.

Once registered and logged in, I'd like them to include more info like phone, email and avatar.

Can all that just go into 1 table, and use session info to locate member_id? Do I use an INSERT query or an UPDATE query?
Reply With Quote
  #2 (permalink)  
Old 08-05-11, 10:43
paullopez's Avatar
Administrator
 
Join Date: Nov 2010
Posts: 195
Default

You can do this in more then one action. That is how most systems work. You would do an initial INSERT query when the user registers, and then use an UPDATE query when the record exists.
__________________
"I'm not anti-social; I'm just not user friendly"
Reply With Quote
  #3 (permalink)  
Old 11-08-11, 01:50
BOD Member
 
Join Date: Nov 2011
Posts: 12
Cool Add info from 2 separate forms

In MY SQL you can add to different form but it the major issue is then in what manner you want to add the form. If you want to change the database then you can change easily by two way first one is by the script and another one is manually or directly opening database.
Reply With Quote
Reply


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump


All times are GMT -6. The time now is 00:55.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
Copyright © 1999-2012, BODHost Ltd. All rights reserved.