Вы не зашли.
#1.
Ulfat
Off
(0)
Участник
2010.05.10 12:12
U menya top reyting statistika po stranam povtaraetsya kak mozhna popravit?
Primer:
xhtml htmlkod 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 13:01)
в какой таблице хранятся страны?
GROUP BY `top_operators`.`country`
#4.
Ulfat
Off
(0)
Участник
2010.05.10 14:02
Gemorroj написал:
GROUP BY `top_operators`.`country`
Kuda dobavit?
#6.
Ulfat
Off
(0)
Участник
2010.05.10 15:03
paluchilas nu sechas xit ne pravilna pokazivaet
Primer:
New|
Staroe
#7.
Ulfat
Off
(0)
Участник
2010.05.10 16:04
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 16:04)
верни таблицы плз. в запросах куча хлама, и мне не совсем понятна структура хранения данных.
Код:
| SELECT `top_operators`.`country`, SUM(`top_operators_stat`.`count`) AS `cnt` |
| 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 |
| GROUP BY `top_operators`.`country` |
| ORDER BY `cnt` DESC |
