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
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
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:
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:
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
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
6 matches
Mail list logo