Hi there everyone,
I’m using the following code to populate cities from a huge database:
Show All
This works great, no problems BUT the client now needs is so the cities are
grouped
Well, first of all.. your subject line mentions GROUP BY which is a database
function for telling the query what to use when performing aggregate functions
like sum, count, average, etc type functions.
That's really not what you're looking at doing here it sounds like. Sounds
like you just wa
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:
Subject: [PHP-DB] GROUP BY? Urgent
tien
>From: "Chris Payne" <[EMAIL PROTECTED]>
>To:
>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 c
Chris Payne wrote:
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
yo
rrange the data to have Akron - Central, Akron - SE (so
that all is in a standard format)
Bastien
>From: "Chris Payne" <[EMAIL PROTECTED]>
>To:
>Subject: [PHP-DB] GROUP BY? Urgent help needed with selection list
>Date: Sun, 23 Jan 2005 00:46:18 -0500
>
>Hi th