RE: [PHP] inserting data to mutliple mysql tables
Isn't this more of a database question than a PHP question?
-Original Message-
From: Peter [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 1:38 PM
To: Php
Subject: [PHP] inserting data to mutliple mysql tables
Hi,
I have a table that's full of references to indexs in other tables if I want
to insert a new record do I have to make a script to insert into all the
tables ie:
insert script for table 1
insert script for table 2
insert script for table 3
insert script for table 4
or can I have it all in one insert statement like you can with the SELECT
statement ie
INSERT INTO table1, table2, table3, table4 (blah, blah1, blah2, blah3,
blah4, blah5) VALUES('$blah', '$blah1', '$blah2', '$blah3', '$blah4',
'$blah5');
and if i can do it that way how do i get the table referencing the indexes
to show the reference number rather than the actual inputted data ie: say
table1 is the reference table and table 2 is the table that matches up the
username with the real name where i want the actual full information to be
stored.
eg table 1
id userid
1 10
table 2
id username nameid
10 boo 15
table 3
id name extra fields in here
15 bob Smith
now when i add a new record I want table one to be have the new userid added
to it table 2 to have the full user name matched to their nameid inserted
and table 3 to get the full name of the person...
any ideas?
Cheers
Peter
the only dumb question is the one that wasn't asked
--
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
Re: [PHP] inserting data to mutliple mysql tables
This is a MySQL question, not a PHP question.
Anyway, with MySQL you can't do this as a single operation. Do your
inserts one after the other. You can use mysql_insert_id() after each one
to get the value of an auto_increment field that was created, and feed
that into your next SQL statement.
miguel
On Mon, 13 May 2002, Peter wrote:
I have a table that's full of references to indexs in other tables if I want
to insert a new record do I have to make a script to insert into all the
tables ie:
insert script for table 1
insert script for table 2
insert script for table 3
insert script for table 4
or can I have it all in one insert statement like you can with the SELECT
statement ie
INSERT INTO table1, table2, table3, table4 (blah, blah1, blah2, blah3,
blah4, blah5) VALUES('$blah', '$blah1', '$blah2', '$blah3', '$blah4',
'$blah5');
and if i can do it that way how do i get the table referencing the indexes
to show the reference number rather than the actual inputted data ie: say
table1 is the reference table and table 2 is the table that matches up the
username with the real name where i want the actual full information to be
stored.
eg table 1
id userid
1 10
table 2
id username nameid
10 boo 15
table 3
id name extra fields in here
15 bob Smith
now when i add a new record I want table one to be have the new userid added
to it table 2 to have the full user name matched to their nameid inserted
and table 3 to get the full name of the person...
any ideas?
Cheers
Peter
the only dumb question is the one that wasn't asked
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] inserting data to mutliple mysql tables
You have to do separate inserts...you can't JOIN inserts like that...
---John Holmes...
-Original Message-
From: Peter [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 8:38 PM
To: Php
Subject: [PHP] inserting data to mutliple mysql tables
Hi,
I have a table that's full of references to indexs in other tables if
I
want
to insert a new record do I have to make a script to insert into all
the
tables ie:
insert script for table 1
insert script for table 2
insert script for table 3
insert script for table 4
or can I have it all in one insert statement like you can with the
SELECT
statement ie
INSERT INTO table1, table2, table3, table4 (blah, blah1, blah2, blah3,
blah4, blah5) VALUES('$blah', '$blah1', '$blah2', '$blah3', '$blah4',
'$blah5');
and if i can do it that way how do i get the table referencing the
indexes
to show the reference number rather than the actual inputted data ie:
say
table1 is the reference table and table 2 is the table that matches up
the
username with the real name where i want the actual full information
to be
stored.
eg table 1
id userid
1 10
table 2
id username nameid
10 boo 15
table 3
id name extra fields in here
15 bob Smith
now when i add a new record I want table one to be have the new userid
added
to it table 2 to have the full user name matched to their nameid
inserted
and table 3 to get the full name of the person...
any ideas?
Cheers
Peter
the only dumb question is the one that wasn't asked
--
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
RE: [PHP] inserting data to mutliple mysql tables
Thanks every one who replied
Sorry for posting that question here.
Miguel thanks for putting me on the right track with this .. i couldn't get
it to work with mysql_insert_id() but looking that up it basically said that
this one works better LAST_INSERT_ID() but I wouldn't have found that if
you didn't put me in the right direction so thank :)
Cheers
Peter
-Original Message-
From: Miguel Cruz [mailto:[EMAIL PROTECTED]]
Sent: Monday, 13 May 2002 1:40 PM
To: Peter
Cc: Php
Subject: Re: [PHP] inserting data to mutliple mysql tables
This is a MySQL question, not a PHP question.
Anyway, with MySQL you can't do this as a single operation. Do your
inserts one after the other. You can use mysql_insert_id() after each one
to get the value of an auto_increment field that was created, and feed
that into your next SQL statement.
miguel
On Mon, 13 May 2002, Peter wrote:
I have a table that's full of references to indexs in other tables if I
want
to insert a new record do I have to make a script to insert into all the
tables ie:
insert script for table 1
insert script for table 2
insert script for table 3
insert script for table 4
or can I have it all in one insert statement like you can with the SELECT
statement ie
INSERT INTO table1, table2, table3, table4 (blah, blah1, blah2, blah3,
blah4, blah5) VALUES('$blah', '$blah1', '$blah2', '$blah3', '$blah4',
'$blah5');
and if i can do it that way how do i get the table referencing the indexes
to show the reference number rather than the actual inputted data ie: say
table1 is the reference table and table 2 is the table that matches up the
username with the real name where i want the actual full information to be
stored.
eg table 1
id userid
1 10
table 2
id username nameid
10 boo 15
table 3
id name extra fields in here
15 bob Smith
now when i add a new record I want table one to be have the new userid
added
to it table 2 to have the full user name matched to their nameid inserted
and table 3 to get the full name of the person...
any ideas?
Cheers
Peter
the only dumb question is the one that wasn't asked
--
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
