RE: [PHP] counter freezes whole site!

> This code is supposed to write a 24h cookie at first visit, and then > checks for it at every refresh, if the cookie doesnt exist, it increases a > counter on the DB. Simple, right? Then why did it stop working out of the > blue? It loops on the refresh, keeps thinking the cookie is not active, so > it keeps adding +1 to the counter. What am i doing wrong? How can i fix > it? > <? > if ($pvisita == '1') { Try if($_COOKIE['pvisita'] == 1) instead... > break; > } else { > > include ('databaseinfo.txt'); > $ligacao=mysql_connect($h, $u, $p) or die("Erro ao aceder a MySQL"); > @mysql_select_db($DBname) or die("Unable to select database " . $DBname); > $resultado = mysql_query ("select * from counttable where id='0'"); > > if ($resultado) { > $registo = mysql_fetch_array($resultado); > $id = $registo["ID"]; > $contador = $registo["contador"]; > $contador = $contador + 1; > $resultado2 = mysql_query ("update counttable set contador='$contador' > where id='0'"); > setcookie("pvisita", "1", time() + 86400); > header("Location: $PHP_SELF"); > > }else{ > print ("não há registos"); > break; > } Also, for the rest of that, it'd be easier to just issue one query such as: Update countable set contador = contador + 1 where id = 0 ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/