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

PDO returns erroneous columns from within pdt
Hi All,

This is a truly weird behavior:
When using a simple pdo fetch, erroneous columns a

Preserving user-entered linebreaks
Hi, I'm building a web 2.0 thingy from scratch and I wanna display text which users input. It's all

Cache PHP Objects/Classes?
Does anyone have ideas about caching PHP objects using something like: http://memcached.org/

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

Had a simple form script that suddenly stopped working
It was made about a year ago and had been working fine. Last time it was known to work for sure was

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

no idea what to do...
I'm fed up. I had issues with code that I have working on a different site that didn't work on my cu

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

Best PHP Documentation generator
Hello guys!

I would like to hear from you what is the best PHP documentation generator. Perso