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