RE: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

Please note that his solution uses a subselect - and your version of mysql may not support subselects. Subselects were introduced (I believe) in Mysql 4.1 - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -----Original Message----- From: Sebastian Mendel [mailto:lists@sebastianmendel.de] Sent: Thursday, November 11, 2004 6:42 AM To: php-db@lists.php.net Subject: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at // send Messages $sql = ' INSERT INTO hf_privmessages (ownerID,fromID,toID,from_name,to_name,priority,date,`subj ect,message,folder`) SELECT userID AS ownerID, ' . (int) $userID . ' AS fromID, userID AS toID, "' . $username . '" AS from_name, nickname AS to_name, "' . $_POST['priority'] . '" AS priority, NOW() AS date, "' . $subject . '" AS subject, "' . $message . '" AS message, "inbox" AS folder WHERE userID IN (' . implode( ', ', $_POST['rcvID'] ) . ') ';