date_default_timezone_set("America/New_York"); $date = date("Y-m-d"); $link = @mysql_connect("localhost", "hosttown.dk", "host2002"); @mysql_select_db("hosttown"); $result = @mysql_query('select * from notused'); if(@mysql_num_rows($result)==0) { // Hvis der ikke er nogen i notused $result = @mysql_query("select max(id) as new_id from counter"); $row = @mysql_fetch_array($result); $new_id = $row["new_id"] + 1; $result = @mysql_query("insert into counter set id=$new_id, created='$date'"); } else { // Hvis der er nogen i notused, bruges de først $result = @mysql_query('select * from notused order by id asc limit 1'); $row = @mysql_fetch_array($result); $new_id = $row[id]; $result = @mysql_query("delete from notused where id=$new_id"); $result = @mysql_query("insert into counter set id=$new_id, created='$date'"); } //@mysql_close($link); include("include/functions.php"); top("q-counter.com | fast simple free web counter"); ?> hits