Hi folks!

The following problem:

I got a db (mysql) with information about doctors.
Name, adress, phone etc.

Now I'm reading these information with a simple 
mysql-query:

$queryString =  "SELECT DISTINCT m.$sureName, m.$preName, m.$prax, m.$title,
";
$queryString .= "p.$town, p.$zip, p.$phone, p.$description ";
$queryString .=  "FROM $medTable m, $praxTable p WHERE ";
$queryString .= "m.$prax = p.$id";

Normally, I print out the information like this:

Dr. med. John Doe                       // $title, $preName, $sureName
(shared practice)                       // description
Elmstreet 13                    // $street
666 Amityville 23                       // $zip, $town
phone: 0049 - 815 - 4711        // $phone

Okay. Now some of these folks are sharing a practice 
($description in the above code == "shared practice").

I would like to have these grouped together like this:

Dr. med. John Doe                       // $title, $preName, $sureName
Dr. med. Allan Smithee          
(shared practice)                       // description
Elmstreet 13                    // $street
666 Amityville 23                       // $zip, $town
phone: 0049 - 815 - 4711        // $phone

I am starting to get a little confused right here and right now.
This is the reason for being THIS detailed, too ;) Don't want to
mix anything up.

How would you achieve this goal fastest and "best"?
Creating a temp array and checking for double $description-s
which I store in the temp array and delete from the original one?
Or check this with the original array? How?
I found functions to get the value for one key in a hash, but not 
for several values with the same key...

Sorry for the confusion, starting to get fuzzy...

Any ideas, hints?

Thanx alot,

Kiko

-- 
It's not a bug, it's a feature.
christoph starkmann
mailto:[EMAIL PROTECTED]
http://www.gruppe-69.com/
ICQ: 100601600
-- 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to