Hi there,
The problem is, the database is imported from a huge properties database and
can only be imported in the format from the central database of estate
agents, so I can't reformat it in the tables itself.
Each table has the same fields, but one is for condo's, one is for
residential etc ..... however, the client need to be able to do a search all
tables query, and bring the results up as though you are only search 1
table. I've never searched multiple tables before without a relative ID,
what I need is to search all of them as though it is just searching 1, so I
don't think multiple queries would work, hence why I'm trying to do it all
in a single query.
Chris
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: <php-db@lists.php.net>
>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.
--
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
