GROUP BY? Urgent help needed with selection list

["Chris Payne" <cjp@xxxxxxxxxxxxxxxxx>]

Hi there everyone,

 

I’m using the following code to populate cities from a huge database:

 

          <select name="fm_city[]" id="fm_city[]" multiple>

            <option value=0>Show All</option>

            <?

$sqla = "SELECT DISTINCT(Area) FROM MLS_Listings ORDER BY Area";

 

$sql_resulta = mysql_query($sqla,$connection)

            or die("Couldn't execute query.");

while ($row = mysql_fetch_array($sql_resulta)) {

   $Area = $row["Area"];

 

?>

            <option value="<?=$Area?>">

            <?=$Area?>

            </option>

            <? }; ?>

          </select>

 

This works great, no problems BUT the client now needs is so the cities are
grouped, but it’s not so simple.  For example, say you have Akron, Akron
Central etc …. They need them so that ALL Akrons appear together, the
problem is, that also includes some which are SE Akron etc …. So, of course
that appears further down the list under S.  How can I group this way?  I am
pretty lost on this.

 

Any help would REALLY be appreciated.

 

Chris


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005