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

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w

Wrong Info sent Using $get in form
Hi i have this code that i tried to make to send some info from one page to aother with lots of ppls

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

matching numbers inside ( )
I know I can match numbers by just [0-9]+, so I thought matching numbers inside ( ) would be somethi

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

php code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat

Undefined variables
hi
----------------------------------------------------------------------------------------------

PHP hyperlinks generator
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

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