Добро пожаловать, Гость!
сщетчик Форума - Страница 3
Помощь мастерам | сщетчик Форума
LenD : сщетчик Форума
3 Янв 2015Как сделать такой сщетчик что бы писало 45тем +4новых /5854ком + 1044 новых ??? Искал в обмене не нашёл нечего (
Комментарии:
Saint
3 Янв 2015Вика, поправил пост и вывел как просил автор "45тем +4новых /5854ком + 1044 новых"
______________________
Я есть сущность
Вика 
3 Янв 2015
Saint (3 Янв 2015):
LenD,
<?
$count = mysql_fetch_assoc(mysql_query("SELECT * FROM (
SELECT COUNT( * ) AS forum_posts FROM `forum_p`) AS q1, (
SELECT COUNT( * ) AS forum_posts_new FROM `forum_p` WHERE `time` > '".(time()-60*60*24)."') AS q2, (
SELECT COUNT( * ) AS forum_themes FROM `forum_t`) AS q3, (
SELECT COUNT( * ) AS forum_themes_new FROM `forum_t` WHERE `time` > '".(time()-60*60*24)."') AS q4
"));
echo $count['forum_themes'].'тем/+'.$count['forum_themes_new'].'/'.$count['forum_posts'].'ком/+'.$count['forum_posts_new'].'новых';
?>
Saint, Во это что надо))))LenD,
<?
$count = mysql_fetch_assoc(mysql_query("SELECT * FROM (
SELECT COUNT( * ) AS forum_posts FROM `forum_p`) AS q1, (
SELECT COUNT( * ) AS forum_posts_new FROM `forum_p` WHERE `time` > '".(time()-60*60*24)."') AS q2, (
SELECT COUNT( * ) AS forum_themes FROM `forum_t`) AS q3, (
SELECT COUNT( * ) AS forum_themes_new FROM `forum_t` WHERE `time` > '".(time()-60*60*24)."') AS q4
"));
echo $count['forum_themes'].'тем/+'.$count['forum_themes_new'].'/'.$count['forum_posts'].'ком/+'.$count['forum_posts_new'].'новых';
?>
Прошу прощение за сылку сайт тестовой(((( код не правильный Saint
3 Янв 2015LenD,
<?
$count = mysql_fetch_assoc(mysql_query("SELECT * FROM (
SELECT COUNT( * ) AS forum_posts FROM `forum_p`) AS q1, (
SELECT COUNT( * ) AS forum_posts_new FROM `forum_p` WHERE `time` > '".(time()-60*60*24)."') AS q2, (
SELECT COUNT( * ) AS forum_themes FROM `forum_t`) AS q3, (
SELECT COUNT( * ) AS forum_themes_new FROM `forum_t` WHERE `time` > '".(time()-60*60*24)."') AS q4
"));
echo $count['forum_themes'].'тем/+'.$count['forum_themes_new'].'/'.$count['forum_posts'].'ком/+'.$count['forum_posts_new'].'новых';
?>
______________________
Я есть сущность
