Re: key pairs
| From: | Tim Ward | Date: | Tue, 17 Dec 2002 20:45:23 +0000 |
| Subject: | Re: key pairs | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-128606@lists.php.net to get a copy of this message | ||
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:timward@chessish.com
----- Original Message -----
From: Ashley M. Kirchner <ashley@pcraft.com>
To: Tim Ward <timward@chessish.com>
Cc: PHP-General List <php-general@lists.php.net>
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:ashley@pcraft.com> .
> 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
>
>