Menu
Community /Pin to ProfileBookmark
@NogDogJul 20.2011 — #Making guesses at table names/columns, so you'll have to fix those:
Populate data from 2 different tables into one listbox
Hi all,
I need to populate the country data and city data into one listbox.
I have a table name country, and table city with country id.
I have no idea how to make it.
I believe there is something to do with php code too.
But i have no picture yet.
Please show me the way.
Thanks in advanced.
the listbox should b like this:
Malaysia
->Melaka
->Selangor
->Sabah
Thailand
->Bangkok
->Chiang Mai
->Chiang Rai
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogJul 20.2011 — #Making guesses at table names/columns, so you'll have to fix those:[code=php]
<?php
$sql = "
SELECT
country.name AS country_name,
city.name AS city_name,
city.id AS city_id
FROM country
INNER JOIN city ON city.country_id = country.id
ORDER BY country_name, city_name
";
$result = mysql_query($sql);
$countries = array();
while($row = mysql_fetch_assoc($result)) {
$countries[$row['country_name']][] = array(
'id' => $row['city_id'],
'city' => $row['city_name']
);
}
echo "<select name='city'>n";
foreach($countries as $country => $cities) {
printf("<optgroup label='%s' />n", htmlspecialchars($country));
foreach($cities as $city) {
printf(
"<option value='%d'>%s</option>n",
$city['city_id'],
htmlspecialchars($city['city_name'])
);
}
}
echo "</select>n";
[/code]