Simultaneous select/update/insert

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

Hi

How would I need to go about when 2 users update a single row simultaneous? And how would I need to go about when 2 users want to edit a row?

Should I first lock the table, update the row to indicate who is editing the data unlocking the table and selecting the row where the editor_id = the current user_id? Plus what happens when I lock the table do other users get a failed query? and what errno does mysql return in this case?

Do I need to use not null on required fields or should I leave it out?

Your Answer:

Login to answer

Other forums

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u

rename the file
File.txt

Code: ***DOCUMENT***
..DN:
000044255
..CB:
..SN:
..PY:
2009
..E

Searching keywords from array
Hello everyone, Im just wondering if someone could help me with another issue im having. Im still le

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

.htpasswd Registration Form
Hi,
I wanted to make an htpasswd registration form.
I found this code on the internet but have

CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.
I post it here because ther