Actually, there is another way of doing it. The prerequisite for this method, is that you have an auto_incremented column. If you have that, then all you have to do is insert a value into one of the columns, then grab mysql_insert_id, and update all columns, corresponding 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. 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 painting yourself into a corner if you had to move to another > platform. > > TIM > -What if the Hokey-Pokey really is what it's all about? > > > > -----Original Message----- > > From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] > > > I actually have an easy way to do INSERTs like this. > > > > First I create the array: > > > > $MyArray["field"] = value; > > $MyArray["name"] = "Jonathan"; > > $MyArray["age"] = 123; > > $MyArray["email"] = $email_address; > > > > and then I define this function somewhere in a function library: > > > > function Array2Query($dbArray) > > { > > foreach($dbArray as $dbField => $dbValue) > > { > > $dbQuery .= "$dbField='$dbValue',"; > > } > > > > $dbQuery = substr($dbQuery,0,strlen($dbQuery)-1); > > > > return $dbQuery; > > } > > > > and then I just create the query: > > > > $Query = "INSERT INTO table SET " . Array2Query($MyArray); > > $Result = mysql_query($Query); > > > > Hope it helps. > > > > - Jonathan > > > -- > 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] > > -- 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]
