diff options
Diffstat (limited to 'includes/funktion_counter.php')
| -rw-r--r-- | includes/funktion_counter.php | 36 |
1 files changed, 13 insertions, 23 deletions
diff --git a/includes/funktion_counter.php b/includes/funktion_counter.php index 70b104d4..39d65a1f 100644 --- a/includes/funktion_counter.php +++ b/includes/funktion_counter.php @@ -1,24 +1,14 @@ -<?PHP - -$SQL = "SELECT `Anz` FROM `Counter` WHERE `URL`=\"". $Page["Name"]. "\""; -$Erg = mysql_query($SQL, $con); - -echo mysql_error($con); - -if(mysql_num_rows($Erg)==0) -{ -// echo "Counter: 1"; - $SQL = "INSERT INTO `Counter` ( `URL` , `Anz` ) ". - "VALUES ('". $Page["Name"]. "', '1');"; - $Erg = mysql_query($SQL, $con); -} -elseif(mysql_num_rows($Erg)==1) -{ -// echo "Counter: ". (mysql_result($Erg, 0, 0)+1); - $SQL = "UPDATE `Counter` SET `Anz` = '". (mysql_result($Erg, 0, 0) +1). "' ". - "WHERE `URL` = '". $Page["Name"]. "' LIMIT 1 ;"; - $Erg = mysql_query($SQL, $con); -} - - +<?php + $SQL = "SELECT `Anz` FROM `Counter` WHERE `URL`=\"" . $Page["Name"] . "\""; + $Erg = mysql_query($SQL, $con); + + echo mysql_error($con); + + if(mysql_num_rows($Erg) == 0) { + $SQL = "INSERT INTO `Counter` ( `URL` , `Anz` ) VALUES ('" . $Page["Name"] . "', '1');"; + $Erg = mysql_query($SQL, $con); + } elseif(mysql_num_rows($Erg) == 1) { + $SQL = "UPDATE `Counter` SET `Anz` = '" . (mysql_result($Erg, 0, 0) +1) . "' WHERE `URL` = '" . $Page["Name"] . "' LIMIT 1 ;"; + $Erg = mysql_query($SQL, $con); + } ?> |