Re: MySQL Timing Issue??

It does take some finite amount of time for MySQL to return the results of a query. Since the PHP script is not event driven (strictly procedural) you have no way of knowing when that query is complete. The best thing to do is to open different connections to MySQL for each query. Maybe if you process the results of each query (print them to HTML, store them in variables,...) prior to executing the next, you would have better luck since the queery would need to be completed before the subsequent processing step. Bob Lutz Charles Killian wrote: > I experienced the same problem nesting queries with Oracle. The fix came > down to using different connections when performing the queries. Give > opening a new connection for each query and see if that fixes the problem. > > Charles > > ----- Original Message ----- > From: "Jason Cox" <jasonc@webpipe.net> > To: <php-general@lists.php.net> > Cc: <php-db@lists.php.net> > Sent: Friday, August 18, 2000 3:13 PM > Subject: [PHP] MySQL Timing Issue?? > > Before I waste anyone's time by posting code, I was wondering if anyone has > experienced this same sort of behavior. When performing multiple queries in > succession, MySQL doesn't return the data but won't return an error either. > I'm not sure if this is a MySQL issue or a PHP issue. The odd thing is that > is > only does it sometimes and it's very unpredictable. This isn't a code > specific > issue either I think because it's happened on a number of server all running > Linux with different code. Might be a MySQL config issue but I'm not sure > what. > > Can anyone shed any light on this? > > Jason > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net