Fórum - Joomla! Brasil

# Query the database       
$database->setQuery( $query );
$rows = $database->loadObjectList();

$i=0;

# Put the output on screen
$content .="<table width=\"100%\" class=\"moduletable\"".$moduleclass_sfx."\">";
$content .="<tr>";

foreach($rows as $row) {

# Set up database query for images
$query1 = "SELECT id, path, fname, type, ordering, publish
FROM #__autostand_images
WHERE objid='$row->id' AND ordering=1";

# Query the database for images
$img = "";
$database->setQuery( $query1 );
$database->loadObject($img);

#build image path
$imgpath = $mosConfig_live_site . $img->path . "t" . $img->fname . $img->type;

if (($i==3) || ($i==6) || ($i==9) || ($i==12) || ($i==15)) {
$content .= "</tr><tr>";
}

$content .= "<td valign=\"top\" width=\"154\" style=\"text-align:center\">";

$content .= "<br><div class='box'  style=\"width:154px; \">";
$content .= "<div class='boxtop'><div></div></div>";
$content .= "<div class='boxcontent'>";

$content .= "<div><a href=\"".sefRelToAbs("index.php?option=com_autostand&act=object&task=showEO&id=".$row->id)."\" ><img src='$imgpath' style=\"border: 2px solid #fff;\"  /></a></div><br>";
if ( $showtitle ) {
//$content .= "<div>";
$content .= "<div style=\"text-align:center; font:#fff; \"><a href=\"".sefRelToAbs("index.php?option=com_autostand&act=object&task=showEO&id=".$row->id)."\"  style=\"font:#fff;\">".$row->title."</a></div>";
}

$content .= "</div>";
$content .= "<div class='boxbottom'><div></div></div></div>";
$content .= "</td>";
$i++;
}

$content .="</tr></table>";