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