Yes, that advice worked perfectly. Now I understand. This is one very nice data storage system. It's fast, and it can deal with multiple pointers - separate sessions - into the same table without conflict. I guess it's up to the programmer to make certain that one connection doesn't change data the other is dependent on :)
Thanks for the great idea. -m- -----Original Message----- From: Antony Dovgal [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 10:30 To: [EMAIL PROTECTED] Subject: Re: Possible: Update query within another query's loop? On Thu, 28 Aug 2003 16:23:35 +0200 Fred van Engen <[EMAIL PROTECTED]> wrote: > You need to make a separate connection to MySQL for the outer query to > prevent the inner query from messing up the outer query's result set. > See the PHP manual for obtaining the connection id's from mysql_connect > and using them with other mysql functions. ouch! it's a kinda bad advice. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
