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" <[EMAIL PROTECTED]>
To: <[email protected]>
Subject: [PHP-DB] 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
