Very interesting. I didn't know you could use SET with an INSERT. I tried this on MySQL
and it worked. Dunno if it's standard SQL, but it didn't work on MSAccess and MS
SQLServer
(the only other DBs I have at hand to test it with). I wonder what other DBs it works
on,
because you could be
to that
auto_incremented value. That's what I ended up doing.
- Original Message -
From: Tim Foster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 28, 2001 10:37
Subject: RE: [PHP-DB] inserting mysql data using php array???
Very interesting. I didn't know you could use SET with an INSERT
Khan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 10:04 AM
To: Tim Foster
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] inserting mysql data using php array???
Actually, there is another way of doing it. The prerequisite for this
method, is that you have an auto_incremented
meaning
INSERT INTO table (first_name,middle_name,last_name,suffix)
VALUES($an_array)
no. that is not possible.
you do actually have to write it out..
INSERT INTO table (first_name,middle_name,last_name,suffix)
VALUES('$name[0]', '$name[1]', '$name[2]', $name[3])
I dont understand why you
);
$Result = mysql_query($Query);
Hope it helps.
- Jonathan
-Original Message-
From: justin gruenberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 2:59 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] inserting mysql data using php array???
meaning
INSERT INTO table