[PHP-DB] Re: [PHP] MySQL Timing Issue?? From: Bob Lutz (php <email protected>)
Date: 08/19/00

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 <email protected>>
> To: <php-general <email protected>>
> Cc: <php-db <email protected>>
> 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 <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>