typo in the querystring, this should work, i suppose
$queryString = "SELECT count(m.*) parxdocs
m.$sureName,
m.$preName,
m.$title,
m.prax,
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";
"Michael Virnstein" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> B120D7EC8868D411A63D0050040EDA77111BE9@XCHANGE">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:[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
