$editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlspecialchars($_SERVER['QUERY_STRING']); } $ip=$_SERVER['REMOTE_ADDR']; $database = $database_currently; $day = date("Y-m-d"); $daytime = date("Y-m-d H:i:s"); mysql_select_db($database_rscn, $rscn); $query_rscurrent = "SELECT * FROM count where ip = '$ip' and iday = '$day'"; $rscurrent = mysql_query($query_rscurrent, $rscn) or die(mysql_error()); $row_rscurrent = mysql_fetch_assoc($rscurrent); $totalRows_rscurrent = mysql_num_rows($rscurrent); mysql_select_db($database_rscn, $rscn); $query_rscurrentmax = "SELECT num FROM count where num=(select max(num) from count)"; $rscurrentmax = mysql_query($query_rscurrentmax, $rscn) or die(mysql_error()); $row_rscurrentmax = mysql_fetch_assoc($rscurrentmax); $num = $row_rscurrentmax['num']; if ($totalRows_rscurrent != 0){ } if ($totalRows_rscurrent == 0) { ++$num; $insertSQL = sprintf("INSERT INTO count (ip, iday, num, daytime) VALUES (%s, %s, %s, %s)", GetSQLValueString($ip, "text"), GetSQLValueString($day, "date"), GetSQLValueString($num, "text"), GetSQLValueString($daytime, "date")); mysql_select_db($database_rscn, $rscn); $Result1 = mysql_query($insertSQL, $rscn) or die(mysql_error()); } mysql_free_result($rscurrentmax); mysql_free_result($rscurrent); ?>