Тема: Счетчик обитателей (Движок DCMS-Social/Поиск скриптов)

Dreamer (9 Nov 2014 в 15:30)
Держи.

Siberiya (9 Nov 2014 в 15:32)
echo \"<center><font color=\'green\'>C нами уже <a href=\'/user/users.php\'>(<font color=\'blue\'>\".mysql_result(mysql_query(\"SELECT COUNT(*) FROM `user`\",$db), 0).\"</font>) + <font color=\'red\'>\".mysql_result(mysql_query(\"SELECT COUNT(*) FROM `user` where `date_reg` > \'$ftime\' \",$db), 0).\"</font> чел.</a></font></center>\";

Wapbest (9 Nov 2014 в 15:40)
А как сделать так:
Обитатели (...) М:... Ж:...

Saint (9 Nov 2014 в 15:41)
<?
$count_st = mysql_fetch_assoc(mysql_query(\"SELECT * FROM (
SELECT COUNT( * ) AS all_user FROM `user`) AS q1, (
SELECT COUNT( * ) AS user_new FROM `user` WHERE `date_reg` > \'\".(time()-60*60*24).\"\') AS q2
\"));
echo \'(\'.$count_st[\'all_user\'].\') +\'.$count_st[\'user_new\'];
?>

StuDenT09 (9 Nov 2014 в 15:42)
<?
$k_p=mysql_result(mysql_query(\" SELECT COUNT(*) FROM `user` \"),0).\"\";
$k_n= mysql_result(mysql_query(\"SELECT COUNT(*) FROM `user` WHERE `date_reg`> \'\".$ftime.\"\'\",$db), 0);
if ($k_n==0)$k_n=NULL;
else $k_n=\' +\'.$k_n;
echo \"($k_p)<font color=\'red\'>$k_n</font>\";
?>

Dreamer (9 Nov 2014 в 15:42)
Wapbest, Держи.

Saint (9 Nov 2014 в 15:44)
Wapbest, <?
$count_pol_st = mysql_fetch_assoc(mysql_query(\"SELECT * FROM (
SELECT COUNT( * ) AS man FROM `user` WHERE `pol` = \'1\') AS q1, (
SELECT COUNT( * ) AS woman FROM `user` WHERE `pol` = \'0\') AS q2
\"));
echo \'М : (\'.$count_pol_st[\'man\'].\') <br/> Ж : (\'.$count_pol_st[\'woman\'].\')\';
?>

Источник: http://www.dcms-social.ru/forum/13/23/55316/