Hi,
First you insert the record in the main table, then using the mysql_insert_id()
finction (Check www.php.net/mysql_insert_id for
details) you retrieve the new auto_increment value and then you insert the records in
the related tables.
your script should look something like this:
<?
$res=mysql_query("insert into main (id,field_one,...) values
(null,'$field_one',...)",$db);
$id=mysql_insert_id():
mysql_query("insert into table_one (id_main,table_one_field_one,...) values
($id,$table_one_field_one,...)",$db);
....
mysql_query("insert into table_six (id_main,table_six_field_one,...) values
($id,$table_six_field_one,...)",$db);
?>
Regards
Dobromir Velev
Web Developer
www.websitepulse.com
-----Original Message-----
From: es said <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, November 30, 2001 12:55
Subject: [PHP-DB] set primary key of a mysql-table automatically as value in other
tables of the same db
>how to set the primary key of a mysql-table automatically as value in other
>tables of the same db via php?
>
>hi there,
>as being a newbie in this list, i don't know if my problem already has being
>solved. so here it is:
>
>i created a database containing 6 tables: 'main' got the key 'id_main'
>(integer auto_increment), every other table got the field 'id_main'(integer)
>too, to connect all of them.
>so, if I enter a new set of data via a php-form, the value $id_main is
>automatically given by mysql. but how do I tell the program to enter the
>same value $id_main in all of the other tables, because the value is given
>in mysql and not via php...?
>(maybe it would be better to automatically get the id of the last set and
>add 1. if someone got a script for this, i would be happy, too!)
>hopefully i was able to explain my question properly and someone got an
>answer. have a nice day!
>thanx
>cornelia
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
