location.href='$PHP_SELF';"; } } ?> Entries older than 1 hour will be deleted

Name: Text: "; if ($add && $text != ""){ $timer = $time-3600; // delete old entries $delete_it = mysql_query("DELETE FROM chat WHERE time < $timer"); $ip = getenv("REMOTE_ADDR"); $name_id = strip_tags($name_id); $text = strip_tags($text, ''); if($name_id != "Your name" && $text != "Your message"){ mysql_query("insert into chat (ip,name_id,text,time) values ('$ip', '$name_id', '$text', '$time')"); if (!$HTTP_COOKIE_VARS[name_id_chat]){ echo ""; } } } // chatters $chat_time = $time-120; $chatresult = mysql_query("SELECT * FROM chat WHERE time > '$chat_time' GROUP BY name_id"); $chatters = mysql_num_rows($chatresult); while ($row = mysql_fetch_array($chatresult)){ echo "$row[name_id] | "; } echo "
Chatters: $chatters"; mysql_close(); ?> 0) { while($row = mysql_fetch_array($result)){ $time = date("d. F Y H:i",$row[time]); echo "$row[name_id]: "; echo "$row[text]"; echo "
"; } } ?>