Page 1 of 1

First PRIORITY(First come First served)

Posted: Fri Jan 27, 2006 3:52 am
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

Posted: Fri Jan 27, 2006 3:55 am
by Jenk

Posted: Fri Jan 27, 2006 7:18 am
by khaki_monster
tanx Jenk!

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

cherz!

Posted: Fri Jan 27, 2006 7:24 am
by Jenk
It certainly gives first come first served, but other priorities will be difficult with PHP.

Posted: Fri Jan 27, 2006 7:25 am
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.

Posted: Fri Jan 27, 2006 8:36 am
by khaki_monster
alright'dy then. i'll give a try.

tanx for the tips and help guyz!

cheerz!