RE: [PHP-DB] GROUP BY? Urgent help needed with selection list

[Bastien Koert]

Ah, that's ugly. Non-standard data is a bitch to make work. What i would do 
then is create a virtual column with a case-when-then construct based on an 
instring of area (like akron).  Have a look at the mysql manual 
(http://dev.mysql.com/doc/mysql/en/case-statement.html) for the syntax.

Is there anything preventing you from palying with the data and manipulating 
it on the way into your site? Trying to make the virtual column in to a real 
column that could provide the geo reference for future queries.

Bastien
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <php-db@lists.php.net>
Subject: RE: [PHP-DB] GROUP BY? Urgent help needed with selection list
Date: Sun, 23 Jan 2005 14:03:53 -0500
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php