JOOMD LISTER

<?php

//DB
$db =& JFactory::getDBO();
$queryz = "SELECT * FROM mao_directory_entry WHERE published = '1' ORDER BY ordering";

$db->setQuery( $queryz );

$rows = $db->loadObjectList();

foreach($rows as $row)
{
$idd=$row->id;
$title = $row->title;
echo "<a href='index.php?option=com_joomd&view=joomd&layout=detail&id=".$idd."'><b>".$title."</b></a><br>";
$db2 =& JFactory::getDBO();
$queryz2 = "SELECT * FROM mao_directory_enf WHERE entry_id = '".$idd."' ORDER BY field_id";

$db2->setQuery( $queryz2 );

$rows2 = $db2->loadObjectList();

foreach($rows2 as $row2)
{
$val=$row2->field_value;
$id2=$row2->id;
echo "<b>".$id2."</b> - ".$val."<br>";
}
echo "<hr>";
}

?>