I have this query
$update = "
UPDATE Users t1 SET
WHEN (NewMail=0 OR NewMail IS NULL) THEN 1
ELSE NewMail + 1
UserId = $rUserId
it is executed with other queries..
IT DOES NOT FAIL.
But sometimes it does not update and the NewMail keeps beeing 0. why is that?