Re: Varible insert

Shannon, If your customer can exit out before they have completed all the forms do you want their partial information in your database? If you do not want incomplete records you will want to wait until all fields have been completed before inserting. Look into using sessions to store and pass fields between forms. Otherwise inserting as they complete one form and move to the next wil not take as much write time as one longer series of data. Rich ----- Original Message ----- From: "Shannon Doyle" <shannon@bigblue.net.au> To: <php-db@lists.php.net> Sent: Wednesday, April 04, 2001 9:47 PM Subject: [PHP-DB] Varible insert > Hi People, > > It seems like all I am doing lately is going into areas of php that I > haven't done before and get stuck. Anyway, here is another small request > that I have. > > I have a series of pages that must insert into a mysql database the results > of the entries. I know how to insert these details into a database, however > there are over 200 entries across 20 or so pages. What I am in need of doing > is the following: > > Is there a way of creating one insert statement that can be used by all > pages to insert the data from the fields into the appropriate fields in the > database? ie the sql insert statement is dynamic and will adapt. > > I have an idea that maybe the "get" method on the form will be of some help, > but not sure. > > Any ideas etc would be helpful. > > - Shannon > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >