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

Stuck with preg_replace
Hi,

I'm trying to use preg_replace to remove part of the IP address submitted using a form on

extract a file from zip file
hi,
i know how to unzip a zip file in php, but is there a way to just extract a certain file only

How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t

have trouble in a if condition
The if below is working ok, it check when indexes, name, zipcode and state are empty.
Code: &