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

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

Log $_POST
How would i log submits on a form, by everyone? I want to then echo the number of submissions.

Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, IN

Hits this week counter
I have a counter on my site that tracks hits, IP's, etc. into a mySQL database. It also includes the

MYSQL gen help
This is my Mysql gen. can anyone tell me why this echos

MID(networkset.networkid, 3, 3) AS &q

How many users online in the last 24-hours using time()?
I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in

News script
Hi ...

I am not sure if this is the rite place to post this but if its not sorry

i am

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

Error Messaging not working
I changed the way my form tells the user of an error. But I can't seem to get it to work properly.