i dont understand, because i use mysql num rows and stuff someone on some other webbysite says u have to use lock tables so if someone else changes the table while the script is running then they cant if u lock the tables. but i dont understand anyone know how and what why?
SKANK!!!!!
5
Posting Pro in Training
Recommended Answers
Jump to PostHey.
The LOCK TABLES and UNLOCK TABLES commands are used to block other "sessions" (other scripts, basically) from reading and/or modifying tables while your session is using them.
This is handy …
Jump to Postok so u only loc the table ur using? how is this done?
thanks that makes more sense to me nowSee the examples on the page Atli linked:
eg:
LOCK TABLES t1 READ;
All 6 Replies
Atli
182
Posting Pro
SKANK!!!!!
5
Posting Pro in Training
digital-ether
399
Nearly a Posting Virtuoso
Team Colleague
SKANK!!!!!
5
Posting Pro in Training
Atli
182
Posting Pro
SKANK!!!!!
5
Posting Pro in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.