RE: [PHP] Maybe a stupid question but can it be done?
Just run two inserts. You can't do it with just one. I'd have to guess you have design issues if you have to do this anyhow... ---John Holmes... -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 9:45 PM To: PHP General Subject: [PHP] Maybe a stupid question but can it be done? Ok, Let's try this again, for some reason this didn't post from early today. I have db that has two tables that I am needing to post the same information into both tables, I can't use ID. So I am want to see if there is a sql statement that will let me or how I can do with a php page. I am sorry to ask, I have looked around to see if there any on the net or in my mysql and php books but this seems like a weird task. Chuck Payne Magi Design and Support -- 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] Maybe a stupid question but can it be done?
if the 2 tables have the same name can't he just go INSERT INTO table1, table2 (table1.name=$name, table2.name=$name ... blah); think u can do that .. but again that relies on table names being the same i guess... -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 24 September 2002 12:21 PM To: 'Chuck PUP Payne'; 'PHP General' Subject: RE: [PHP] Maybe a stupid question but can it be done? Just run two inserts. You can't do it with just one. I'd have to guess you have design issues if you have to do this anyhow... ---John Holmes... -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 9:45 PM To: PHP General Subject: [PHP] Maybe a stupid question but can it be done? Ok, Let's try this again, for some reason this didn't post from early today. I have db that has two tables that I am needing to post the same information into both tables, I can't use ID. So I am want to see if there is a sql statement that will let me or how I can do with a php page. I am sorry to ask, I have looked around to see if there any on the net or in my mysql and php books but this seems like a weird task. Chuck Payne Magi Design and Support -- 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Maybe a stupid question but can it be done?
opps same fields even sawwy :) -Original Message- From: Peter Houchin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 24 September 2002 1:49 PM To: 'PHP General' Subject: RE: [PHP] Maybe a stupid question but can it be done? if the 2 tables have the same name can't he just go INSERT INTO table1, table2 (table1.name=$name, table2.name=$name ... blah); think u can do that .. but again that relies on table names being the same i guess... -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 24 September 2002 12:21 PM To: 'Chuck PUP Payne'; 'PHP General' Subject: RE: [PHP] Maybe a stupid question but can it be done? Just run two inserts. You can't do it with just one. I'd have to guess you have design issues if you have to do this anyhow... ---John Holmes... -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 9:45 PM To: PHP General Subject: [PHP] Maybe a stupid question but can it be done? Ok, Let's try this again, for some reason this didn't post from early today. I have db that has two tables that I am needing to post the same information into both tables, I can't use ID. So I am want to see if there is a sql statement that will let me or how I can do with a php page. I am sorry to ask, I have looked around to see if there any on the net or in my mysql and php books but this seems like a weird task. Chuck Payne Magi Design and Support -- 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 -- 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] Maybe a stupid question but can it be done?
if the 2 tables have the same name can't he just go INSERT INTO table1, table2 (table1.name=$name, table2.name=$name ... blah); think u can do that .. but again that relies on table names being the same i guess... No...That's not a valid query. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php