fio city car
"Pupkin","Moscow","1"
"Ivanov","Moscow","1"
"Petrov","Moscow","0"
"Sidorov","Moscow","0"
"Shevcenko","Moscow","1"
"Kovalenko","Piter","0"
"gshsth","Piter","1"
"shthstrhdrt","Piter","1"
"sthtrhdsrthd","Piter","0"
"sththsst","Piter","0"
"seththtrh","Piter","0"
"rjnydtjty","Piter","0"
"sjtyhdt","Piter","1"
"snrhrhgf","Piter","1"
"sdjjdt","Piter","0"
"srthhrdth","Piter","0"
"srhthrth","Piter","1"
"shthrthr","Rostow","1"
"shrthdtrh","Rostow","0"
"sthrthrth","Rostow","1"
1я колонка - фамилия, 2я - город, 3я - наличие автомобиля (1-есть, 0- нет)
Мне нужно составить запрос, чтобы вывести данные в браузер в виде такой таблицы
Город Людей(всего) Людей(с автомобилем)
Moscow 5 3
Piter 12 5
Rostow 3 2
Делаю так:
CODE (text):
скопировать код в буфер обмена
скопировать код в буфер обмена
- print "<table>";
- $result = mysql_query("SELECT city, COUNT(*) AS total FROM people GROUP BY city;");
- while ($string = mysql_fetch_array($result))
- {
- print "<tr align=center>".
- "<td>".$string["city"]."</td>".
- "<td>".$string["total"]."</td>".
- "<td>".$string["cars"]."</td></tr>";
- }
- print"</table>";