Grouping and sorting results
Posted: Wed Nov 04, 2009 9:05 am
Please help with this query.
I have 2 tables in a database, countires and cities. states looks like this
countries
id country
1 uk
2 us
3 japan
cities
id country city
1 1 London
2 1 Manchester
3 2 New York
4 2 Washington
5 2 San Francisco
6 2 Las Vegas
7 2 New Orleans
8 3 Tokyo
I have queried the database as follows:
///////////////////////// Make the country query //////////////////////////////
$q_country = "SELECT * FROM countries";
$result_country = mysqli_query($dbc, $q_country);
$row_country = mysqli_fetch_array($result_country);
///////////////////////// Make the city query //////////////////////////////
$q_city = "SELECT * FROM cities";
$result_city = mysqli_query($dbc, $q_city);
$row_name = mysqli_fetch_array($result_name);
I want to display the data as follows:
Country - UK
Cities - London, Manchester
Country - US
Cities - New York, Washinton, San Francisco, Las Vegas, New Orleans
Country - Japan
Cities - Tokyo
I'm new to PHP and just can't work it out. Please can somebody point me in the right direction?!!!! PLEASE!!!!!
I have 2 tables in a database, countires and cities. states looks like this
countries
id country
1 uk
2 us
3 japan
cities
id country city
1 1 London
2 1 Manchester
3 2 New York
4 2 Washington
5 2 San Francisco
6 2 Las Vegas
7 2 New Orleans
8 3 Tokyo
I have queried the database as follows:
///////////////////////// Make the country query //////////////////////////////
$q_country = "SELECT * FROM countries";
$result_country = mysqli_query($dbc, $q_country);
$row_country = mysqli_fetch_array($result_country);
///////////////////////// Make the city query //////////////////////////////
$q_city = "SELECT * FROM cities";
$result_city = mysqli_query($dbc, $q_city);
$row_name = mysqli_fetch_array($result_name);
I want to display the data as follows:
Country - UK
Cities - London, Manchester
Country - US
Cities - New York, Washinton, San Francisco, Las Vegas, New Orleans
Country - Japan
Cities - Tokyo
I'm new to PHP and just can't work it out. Please can somebody point me in the right direction?!!!! PLEASE!!!!!