yeah, I noticed that ... haven't had a chance to check for certain, but I believe the server I have to work with is 3.23 ... and since my space is rented, I don't have alot of say in upgrading ... although it might be possible to get them to do it ... their PHPMyAdmin is really old too ... :-s

Rene

At 16:17 11-11-2004, Norland, Martin wrote:
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:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 6:42 AM To: [EMAIL PROTECTED] 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'] ) . ')
';

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to