How to lock selected rows from reading in other session?

[salsan]

How to block selected rows from reading in other session unless unlock it?

[zmbd]

Salsan,
You need to provide a little more detail as to how you are accessing the database.

[salsan]

Its for a multithreaded php application accessing mysql database from each instance. Whenever one instance is accessing the database the table must get locked from accessing other instances and other instances should wait till the lock release.

[wholetthedogout]

Can u please put in the code u tried so far.

Thank you.

[zmbd]

The code would be nice.

IMHO: this doesn't seem like a MySQL issue in as much as it is how PHP is opening the recordset and how the servers handle PHP actions.

I can move this thread to the PHP forum if you'd like.

[salsan]

LOCK TABLE email_list WRITE;

SELECT * FROM email_list LIMIT 10;

INSERT INTO .....

UNLOCK TABLES;

This is the query i have used in that.