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?

Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
316 Like 54 Dislike
Previous forums Next forums
Other forums

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

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

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

Echoing If Function?
A script I am using has If statements in the comments form to basically tell the form what to do. Cu

Xml parsing
I need a suggestion about parsing xml with multiply parts like pervious...
i.e. different device

Reading waves
Hi,

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

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

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

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash