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

2005-01-23 Thread Bastien Koert
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

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

2005-01-23 Thread Jochem Maas
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

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

2005-01-23 Thread Chris Payne
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 ...

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

2005-01-23 Thread Bastien Koert
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 help needed with selec

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

2005-01-22 Thread tg-php
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