You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''[clans]' SET pub = pub+1, cof = cof+1, nacht = nacht+1, motel = motel+1, c' at line 1
mysql_query("UPDATE `[clans]` SET
pub=`pub`+'1',
cof=`cof`+'1',
nacht=`nacht`+'1',
motel=`motel`+'1',
casino=`casino`+'1'
WHERE name = '".$data['clan']. "'") or die(mysql_error());