Re: Getting values of duplicate keys in array
| From: | Michael Virnstein | Date: | Thu, 11 Apr 2002 11:56:15 +0000 |
| Subject: | Re: Getting values of duplicate keys in array | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-92544@lists.php.net to get a copy of this message | ||
ok, here we go.
you normaly say this i suppose:
while ($row = mysql_fetch_array($result) {
//your html inserts here
}
if you'd use oracle, i'd suggest using a cursor, but you're using MySql, so
you probably have to do it a bit different:
(Not tested, could contain some errors!!!)
// you'll now have the number of doctors in one praxis in praxdocs
$queryString = "SELECT count(m.*) parxdocs
m.$sureName,
m.$preName,
m.$title,
p.$town,
p.$zip,
p.$phone,
p.$description
FROM $medTable m,
$praxTable p
WHERE m.$prax = p.$id
GROUP BY m.prax, m.$preName, m.$sureName,
m.$title, p.$town, p.$zip, p.$phone, p.$description
ORDER BY m.$prax, m.$preName";
// then output the html
while ($row = mysql_fetch_array($result)) {
// we don't need the first one, because we already have it.
echo "{$row["title"]} {$row["preName"]}
{$row["sureName"]}<br>";
for ($i = 1; $i < $row["praxdocs"]; $i++) {
$doctor = mysql_fetch_array($result);
echo "{$doctor["title"]} {$doctor["preName"]}
{$doctor["sureName"]}<br>";
}
// rest of the output using $row here
}
hope that helps
"Christoph Starkmann" <kiko@nfq.de> schrieb im Newsbeitrag
news:B120D7EC8868D411A63D0050040EDA77111BE9@XCHANGE...
> 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:kiko@nfq.de
> http://www.gruppe-69.com/
> ICQ: 100601600
> --