can someone tell me where i mistake ...

PHP Code:

   $trafficUp       = $trafficResult['in']+1;
   $trafficId       = $trafficResult['Id'];
   mysql_query("UPDATE trafficEx SET in = '$trafficUp' WHERE id = '$trafficId'"); 


is not update my table ...
703b17d5-3b5d-412a-93cb-be1181dbc27e
1.03.01

Hmm... maybe there is something wrong with the database to understand what's happening i suggest you to always add enable mysql error show up by adding "or die(mysql_error())" to your mysql query.. so your code should be:

PHP Code:

$trafficUp       = $trafficResult['in']+1;
$trafficId       = $trafficResult['Id'];
mysql_query("UPDATE trafficEx SET in = '$trafficUp' WHERE id = '$trafficId'") or die(mysql_error()); 


Now it should tell you what's wrong... keep us updated!

are you sure there is value $trafficId in the field "id"?

Originally Posted by elf2002

are you sure there is value $trafficId in the field "id"?

Yes maybe this is the problem this is why I said him to add the function to display errors.

"in" is a reserved keyword, So if you have a column set to that, it probably wont work.

http://dev.mysql.com/doc/refman/5.1/...ved-words.html

What about the lower and upper cases - do you really have ID inserted inside query or not? When using low and upper-case variables, this is a common problem.