Файл: test.masteram.us/besedka/count.php
Строк: 11
<?
/*
echo mysql_result(mysql_query("SELECT COUNT(*) FROM `besedka_post`$adm_add"),0)
*/
$room=mysql_fetch_assoc(mysql_query("SELECT * FROM `besedka_rooms` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"));
$k_p= mysql_result(mysql_query("SELECT COUNT(*) FROM `besedka_post`",$db), 0);
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `besedka_post` WHERE `time` > '".(time()-86400)."'",$db), 0);
$on= mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_who` WHERE `room` = '$room[id]'"), 0);
if ($k_n==0)$k_n=NULL;
else $k_n='+'.$k_n;
echo " <font color='red'>$k_n</font>";
?>