First PRIORITY(First come First served)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
khaki_monster
Forum Commoner
Posts: 73
Joined: Tue Oct 11, 2005 12:36 am
Location: Philippines
Contact:

First PRIORITY(First come First served)

Post by khaki_monster »

hello guyz!

i actually raise this question once, but i was too busy with some project :)

anyway...

given a scenario with two users to accesss some data on the Database. question, how do i give priority to a certain users
accessing the same data at the same time and lock the table to avoid some conflict?

Tips or Help please.

tanx in advanced.

cherz
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post by Jenk »

User avatar
khaki_monster
Forum Commoner
Posts: 73
Joined: Tue Oct 11, 2005 12:36 am
Location: Philippines
Contact:

Post by khaki_monster »

tanx Jenk!

but what about giving priorit? does locking table solved this?

cherz!
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post by Jenk »

It certainly gives first come first served, but other priorities will be difficult with PHP.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

a locked table cannot be updated or inserted into by anyone but the person/connection/session that locked it. So yes, it does solve your priority wish.
User avatar
khaki_monster
Forum Commoner
Posts: 73
Joined: Tue Oct 11, 2005 12:36 am
Location: Philippines
Contact:

Post by khaki_monster »

alright'dy then. i'll give a try.

tanx for the tips and help guyz!

cheerz!
Post Reply