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
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 repre
At 13:42 11-11-2004, Sebastian Mendel wrote:
// send Messages
$sql = '
INSERT INTO `hf_privmessages`
(`ownerID`,`fromID`,`toID`,`from_name`,`to_name`,`priority`,`date`,`subject`,`message`,`folder`)
SELECT `userID` AS `ownerID`,
' . (int) $userID . 'AS `fromID`,
