what do you mean by key pairs - I assumed you meant a key that could link the records in each table. If you've already done that then what's the problem?
Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] ----- Original Message ----- From: Ashley M. Kirchner <[EMAIL PROTECTED]> To: Tim Ward <[EMAIL PROTECTED]> Cc: PHP-General List <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 8:25 PM Subject: Re: [PHP] key pairs > Tim Ward wrote: > > >1. Have an order_id on the first table (or a separate > >ORDER table) that is INT and AUTO_INCREMENT. > >2. Have an order_id on the other table(s) that is INT but > >not AUTO_INCREMENT. > >3. Create the record in the first table just inserting the info > >you get in. > >4. get the order_id just created using mysql_insert_id(). > >5. insert the data into the other table(s) with this order_id(). > > > > > Thanks, but that wasn't the question - I know this part. :) > > I need a routine to run through the data and generate the key pairs > for insertion in the DB. > > -- > W | I haven't lost my mind; it's backed up on tape somewhere. > +-------------------------------------------------------------------- > Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 > IT Director / SysAdmin / WebSmith . 800.441.3873 x130 > Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6 > http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A. > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
