MySQL queries not executed at all from PHP - no error returned

[mk77z]

Hi to everybody,

I have a problem with MySQL queries executed from within PHP; I execute, in the same script, thousands of SELECT/UPDATE queries, but nearly 3000 are NOT EXECUTED AT ALL, nor they return a mysql error like "you've made too many queries and you were blocked by the mysql server". Queries are correct, meaning I print them to screen and execute them via phpmyadmin and they work correctly. The PHP script runs correctly, I had to put set_time_limit(0) in order to wait until the end but no PHP error is returned either.

Does anybody know if there's a MySQL (or PHP) parameter regarding the max number of queries per script (like, 10.000), or the maximum execution time for a connection, after which no error is returned and the connection is simply broken?

Thanks to all

[TobyRT]

Can we have a look at your code?

[Blulagoon]

@

You want to see code that executes in the region of 10,000 different select/update queries!!

@

Are you running PHP/MySQL on your own machine or on one that is provided by a webhost. If the latter, I dare say they take a view on the number of queries you are trying to execute at one time, so it might be worth contacting them.

Blu

Thinks ..... its time to get out of publishing 🙂