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

php include email form with attachment
I have had no luck with finding a email form all over the Internet for various reasons. Some insecur

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Must be a string? Huh, what? HELP?
with the following script, I get
Fatal error: Property name must be a string in /home/content/e/

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

batch file not building to webapps folder
Hello. I just started running Vista :P and can't seem to get my projects deployed. I found out how

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

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