---

Kan dette gøres i et hug ?

$rl = mysql_db_query($database, "SELECT id,navn FROM person,liste
WHERE person.id=liste.personid AND udvalgid=$udvalgid ORDER BY navn
ASC");
while ($r = mysql_fetch_array($rl)) {
   extract ($r);
   $rs = mysql_db_query($database, "SELECT titel FROM
status,liste WHERE status.statusid=liste.status AND personid=$id");
   if ($rss = mysql_fetch_array($rs))
      extract ($rss);
   echo "<p>".$navn.", ".$titel."<br>";
}

--
mvh Leonard - http://leonard.dk/

---

After I finished the 3 Pan Galactic Gargle Blasters, not2@sporty.dk
(Leonard) just offered me, he muttered some weird stuff, and I had to
correct this gibberish:

>Kan dette gøres i et hug ?

Uhm, blindeskud:

$query = "SELECT
   person.id,
   person.navn,
   status.title
FROM
   person,
   liste,
   status
WHERE
   person.id = liste.personid
AND
   udvalgid = '".$udvalgid."'
AND
   status.statusid = liste.status
AND
   status.personid = '".$id."'
ORDER BY
   navn ASC";
--
Martin Mouritzen. | http://www.trendy.dk
The truth is out there! Does anyone know the URL?