Re: Insert statement where value depends on auto-generated value from previous insert

2004-03-18 Thread Scott Plumlee
Found that function right after I posted. Thanks, it should do exactly what I need. Roger Baklund wrote: * Scott Plumlee I've got two separate tables, each with id fields that are auto-increment. The created fields below are timestamps. The tables are Innodb tables using transactions to proce

Re: Insert statement where value depends on auto-generated value from previous insert

2004-03-18 Thread Roger Baklund
* Scott Plumlee > I've got two separate tables, each with id fields that are > auto-increment. The created fields below are timestamps. The tables > are Innodb tables using transactions to process the statements. This > will be an online registration process for our business, using PHP and > MyS

Re: Insert statement where value depends on auto-generated value from previous insert

2004-03-18 Thread Scott Plumlee
Scott Plumlee wrote: I've looked through the PHP Cookbook and the MySQL cookbook and haven't seen a solution. I've thought about trying to make some unique hash with the data to be inserted but if there's another identical set of data, then the hash would match. I can't use a timestamp in the

Insert statement where value depends on auto-generated value from previous insert

2004-03-18 Thread Scott Plumlee
I've got two separate tables, each with id fields that are auto-increment. The created fields below are timestamps. The tables are Innodb tables using transactions to process the statements. This will be an online registration process for our business, using PHP and MySQL. PHP is using sess