if you have kind of geo id number you could use that, failing to have that
info, you could re-arrange the data to have Akron - Central, Akron - SE (so
that all is in a standard format)
Bastien
From: "Chris Payne" <cjp@xxxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Subject: GROUP BY? Urgent help needed with selection list
Date: Sun, 23 Jan 2005 00:46:18 -0500
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
