Locking mysql tables with php

Posted on 16th Feb 2014 07:03 pm by admin

Hi

BACKGROUND:
I have multiple instances of the same php script running in a WAMP environment. The script contains mysql queries to lock certain tables in the database. I'm getting some very odd behaviour which would seem to suggest that the locks are not working, and that one instance of the script is reading from a table that another instance of the script should have a write lock on.

ACTUAL QUESTION:
Do two instances of the same php script running through WAMP get totally independent locks on tables in a database?

I didn't post this question in the mysql forum because although it is about locking tables, it is about locking tables from the point of view of a php script. Please move it if I have posted in the wrong forum.

Cheers

Paul

Your Answer:

Login to answer

Other forums

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problem

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

same querie, or a new one??
Hi guys,

I'm still working on this drop down list. I've got the actual drop down list to wor

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can