Thanks for the tip I will try that, I'm still learning MySQL and PHP, although I did a couple of complex applications, there are some techniques that still are 'obscure' to me.
Regards, Ricardo Fitzgerald AXIS Computers ----- Original Message ----- From: "Chris Shiflett" <[EMAIL PROTECTED]> To: "Axis Computers" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "PHP" <[EMAIL PROTECTED]> Sent: Tuesday, September 10, 2002 7:24 PM Subject: Re: [PHP] Questions regarding inserting and updating data into a MySQL db > You should search for some SQL tutorials on the Web. > > What it sounds like you are looking for is the "update" SQL statement > which modifies an existing row (for your second form, for example). > Thus, you "insert" the row to create it (which assigns the key using the > auto increment), then "update" that row to make any modifications you > need to after that. > > Happy hacking. > > Chris > > Axis Computers wrote: > > > I'm developing a web application that uses forms for user input and > > then after each form is filled shows something like Welcome Bob to our > > site ... bla. bla... inserts data in a table and on the same page > > continues with the rest of the data, and goes to another form and so on. > > > > I have no problems inserting the data from the first form in the > > table, display the personalized message, and then connect to the mySQL > > db, my problem is some fields in the table which must be filled are > > null in this first instance, and then on the second form they are filled, > > but my I donīt know how can I fill the gaps and leave all the data in > > one row, because the first field auto increments, and I'm worried the > > data instead of filling one row spreads accross two or three. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php