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/