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

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

How to find OS bit version
How can I tell the person browsing my site is running 32, or 64 bit operating system?

SAP Treasury - Commodities
We are running SAP ECC 6.0 with Treasury Activated.
EA-FIN is also activated (SFW5).

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

textfield unchanged
hi,
i want my form to know whether its textbox is unchange or not.

if($textbox == 'unchang

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

Line break?
Hi, I'm new to the forum and new to php. I'm not sure if I'm using the correct terminology so here i

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie