Hi,

I'm sometimes experiencing in my application the "commands out of sync; You
can't run this command now" error.
According to the MySQL manuel, it means :
This can happen, for example, if you are using mysql_use_result() and try to
execute a new query before you have called mysql_free_result(). It can also
happen if you try to execute two queries that return data without a
mysql_use_result() or mysql_store_result() in between.

The main question is since I use PHP, should I see this error ? (I mean
mysql_user_result(), mysql_free_result() and mysql_store_result() are
internally called by PHP, but it should be called in the right order so that
this error never happen).
Is this possible it's a bug in PHP (or perhaps in MySQL C API ??).
I'm using PHP 4.2.2 and MySQL 4.0.3 (but 4.2.1 and MySQL 4.0.2 already show
this behaviour).

Any ideas ?

Thanks,
  Jocelyn


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to