I have been scratching my head for a few days now! with this problem:
I am trying to echo out some data from a mysql table.
I have a column name Country which has the following Countries: India, Malaysia Austaralia etc.
I also have a column name Town which has the following Towns: Varkala, Cochin, Kula Lumpar, Sydney, Cairns etc.
Each town is linked with the accosiated countries eg:
India - Varkala
India - Cochin
Malaysia - Kula Lumpar
Australia - Sydney
Australia - Cairns
In php I can echo out each row using while loop, but the problem is I want to group the countries so it will display the country once and all the towns related underneath. For example:
- Kula Lumpar
Please have a look at the problem by visiting the following site:
If you look on the right hand side where it says "Other Blogs".
If you can help I will be very greatful!