$connect = mysql_connect("localhost","sicks","gost0968"); mysql_select_db("sicks", $connect); if(!$udate) { $udate = date("Y-m-d"); } $sql = "select seq from statistics where reg_date = '".date("Y-m-d")."' and domain_name = '{$_SERVER[HTTP_HOST]}' order by cnt desc limit 1"; $result = mysql_query($sql); if($row = mysql_fetch_array($result)) { $sql = "update statistics set cnt = cnt + 1 where seq = '{$row[seq]}'"; mysql_query($sql); } else { $sql = "insert into statistics (domain_name, cnt, reg_date) values ('{$_SERVER[HTTP_HOST]}', '1', now())"; mysql_query($sql); } mysql_free_result($result); mysql_close($connect); ?>