Просмотр поста

Nursoft (14.07.2011/12:43)
Как вывести на главную счетчик Подпапки с загруз центра?

$zap = mysql_fetch_array
(mysql_query("SELECT *
FROM `downpath` WHERE
`id` = 'ид'"));
$old = $realtime - (3 *
24 * 3600);
$countnf = mysql_result
(mysql_query("SELECT
COUNT(*) FROM
`downfiles` WHERE
`type` != 1 && `time` >
'".$old."' && `way` LIKE
'" . $zap['way'] ."%' "), 0);
$countf = mysql_result
(mysql_query("SELECT
COUNT(*) FROM
`downfiles` WHERE
`type` != 1 && `way`
LIKE
'" . $zap['way'] ."%' "), 0);
$countf = mysql_result
(mysql_query("SELECT
COUNT(*) FROM
`downfiles` WHERE
`type` != 1 && `way`
LIKE '" . $zap['way'] ."%'
"), 0);
echo '<div
class="menu"><a
href="адрес">имя</a>
('.$countf;
if($countnf > 0){ echo'+ '.
$countnf; }
echo')</div>';
вроде так