Код модуля - Joomla 1.0: Общие вопросы

$database->setQuery("select country from #__hp_properties where published=1");
$rows=$database->loadObjectList();
foreach($rows as $row)
{
echo "<td><b>" . $row->country . "</b></td>";
}

$database->setQuery("select country from #__hp_properties where published=1");
$rows=$database->loadObjectList();
foreach($rows as $row)
{
echo "<td><b>" . $row->country . "</b></td>";
$db->setQuery("select suburb from #__hp_properties where published=1 and country='$row->country'");
$chak=$db->loadObjectList();
foreach($chak as $ch)
{
echo "<tr><td>". $ch->suburb. "</td></tr>";
}
}