Re: Arbitrary update of fields - Strange ...

[Dr. Thomas W. Richter]

Peter Brawley Wrote:
-------------------------------------------------------
> Implementation logic has failed at at least one
> point in your process To find where that is,
> you'll need to stub out every relevant step of the
> process to a log.

Sorry, but I do not think so. The program logic is very easy and on the test side there no effect, on production side there is this strange behavior. The difference is that one the one side there is no movements whereas on the other one there are movements (update, read, write). I have debugged the android program (java) - and no fault. I must be a fault on php or mysql side.

The program:

<?php

// gibt es einen Nutzer?
/* Gibt es einen Datensatz, der noch in Bearbeitung (status=0) ist? */
// Vorbelegung


if($_SERVER["REQUEST_METHOD"] == "POST") {
require "connect.php";
require "getUser.php";
global $link;

$user = $_POST['persNo'];

// Ist User überhaupt verhanden?
$row = getUser($link);
if ($row == 0 )
$result = "02"; // Kein User NOUSER
else {
if ( $row["pauseStatus"] == 1 ) // PAUSED Pause schon gestartet
$result = "11"; // PAUSED
else {
// Startzeit setzen und Pausenstatus auf besetzt setzen (1)
$dquery = "UPDATE LOW_PRIORITY staffmember SET pauseStart = NOW(), pauseStatus = 1 WHERE persNr = ".$user.";";
$dresult = mysqli_query($link, $dquery) or die(mysqli_error());
$result = "01"; // ISOK
}
}
mysqli_close($link);

echo $result;
}
?>