I have a script that runs several queries to the DB to UPDATE a specific entry in a for loop.
Each UPDATE is adding about 1MB to a column, and I’m afraid that the next UPDATE is sent before the first one is finished writing.
…is that even possible? or does PHP wait for a return from the mysql_query before continuing?
Is there some way to create a “waiting list” for my queries to make sure the first one finishes before the next one tries to write?
I think it might be related to LOCK TABLES or START TRANSACTION - but the documentation was confusing.
I’m using MySQL 4.1.11
Thanks,
-Karl
