I have a table of users with regions and countries for every user.
Now I would like to echo a list of all countries I have in every region.

Something like this:
EUROPE
France
Germany
Norway
Spain
Sweden

SOUTH AMERICA
Argentina
Brasil
Chile

NORTH AMERICA
Canada
USA

I tried the following, but it's not working. What do I need to add/change in this?
PHP Code:
SELECT DISTINCT continent FROM station_db ORDER BY country DESC;

<p><?php do { ?><?php echo $row_rs_countrylist['continent']; ?><?php echo $row_rs_countrylist['country']; ?></p>
<?php } while ($row_rs_countrylist mysql_fetch_assoc($rs_countrylist)); ?>