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

Linkage between two scripts
Okay say I have this for a link in a script:

Code: <li><a href="#&q

unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_
Can anyone view my code and tell me why im getting the error:
Parse error: syntax error, unexpect

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex.

Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

i need help with php header and footer
I have designed a header and footer for my site and they seem to be ok when they are running individ

Question about ShowWindow()
Hello....

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

I've got a CFormView

Is it possible to stop reservation creation in PM Order?
Hi All,

Is it possible to stop reservation creation in PM Order?

Thanks in adv