WAP Мастер Форум
- Вы не зашли.
title
Description
Body
#1 2010.05.10 16:10
vapros php/mysql
U menya top reyting statistika po stranam povtaraetsya kak mozhna popravit?
Primer: xhtml html
kod takoy
$result = mysql_query("
SELECT `top_operators`.`country`, `top_operators_stat`.`count`
FROM `top_operators_stat`
LEFT JOIN `top_operators`
ON `top_operators`.`id` = `top_operators_stat`.`id_operator`
WHERE `date` = '$today' AND `day_week` = $week_day AND `uid` = $uid
ORDER BY `top_operators_stat`.`count` DESC
");
Отредактировано Ulfat (2010.05.10 17:26)
Неактивен
#7 2010.05.10 20:26
Re: vapros php/mysql
Gemorroj, esho est takoy kadirovka
$result = mysql_query("SELECT DISTINCT `top_operators_stat`.`id_operator`, SUM(`top_operators_stat`.`count`) AS `count`, `top_operators`.`country` as `country` FROM `top_operators_stat`, `top_operators` WHERE `top_operators_stat`.`uid` = ".$uid." AND `date` = $date AND `top_operators_stat`.`id_operator` = `top_operators`.`id` GROUP BY `top_operators`.`country` ORDER BY 2 DESC;");
zdes vsego normalnya pakazivaet kromi (Другие) strana ne pokazivaet kak mozhna zdelat chtobi (Другие) strani tozhe pokazall?
Primer: xhtml
Отредактировано Ulfat (2010.05.10 20:27)
Неактивен
#10 2010.05.11 19:49
Re: vapros php/mysql
Код:
|
|
Неактивен