$result = mysql_query("SELECT count FROM mycounter"); $mycounter = mysql_result($result, 0) + 1; $mycounter = number_format($mycounter); $result = mysql_query("UPDATE mycounter SET count = count + 1");