Hola, necesito mostrar los datos de una base de datos en dos columnas y que se vayan agregando filas hacia abajo si hay mas datos con un tope de hasta 6... y no me funciona... este es el codigo y no se como insertar las lienas correspondiente...
Código HTML:
Ver original<?php
global $database;
$Itemid = intval( mosGetParam( $_REQUEST, 'Itemid', '0' ) );
// recent5 can act as a plugin for other extensions so include the language here, too
if(file_exists($mainframe->getCfg('absolute_path').'/components/com_marketplace/language/'.$mainframe->getCfg('lang').'.php')) {
require_once($mainframe->getCfg('absolute_path').'/components/com_marketplace/language/'.$mainframe->getCfg('lang').'.php');
}
else {
require_once($mainframe->getCfg('absolute_path').'/components/com_marketplace/language/english.php');
}
$database->setQuery("SELECT a.id, a.category, a.ad_headline, a.ad_condition, date_format( a.date_created, '%d.%m.%Y' ) AS af_date, b.name"
. "\n FROM #__marketplace_ads AS a, "
. "\n #__marketplace_categories AS b WHERE b.published='1' AND a.published='1' AND a.category = b.id AND a.ad_image > '0'"
. "\n ORDER BY a.id DESC "
. "\n LIMIT 5 ");
$meslist = $database->loadObjectList();
echo "
<table class='jooRecent5' cellspacing='1'>";
echo "
<th width='100%' colspan='5'>";
echo JOO_RECENT5;
foreach ($meslist as $mes){
echo "
<td width='20%' valign='top' >";
echo "<center>";
echo "
<table width='100' height='75' border='0'>";
echo "
<td width='100' height='75' align='center'>";
echo "
<a href=".sefRelToAbs( "index.php?option=com_marketplace&page=show_ad&catid=$mes->category
&adid=$mes->id
&Itemid=$Itemid").">";
$a_pic_jpg = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."a_t.jpg";
$a_pic_png = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."a_t.png";
$a_pic_gif = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."a_t.gif";
$b_pic_jpg = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."b_t.jpg";
$b_pic_png = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."b_t.png";
$b_pic_gif = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."b_t.gif";
$c_pic_jpg = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."c_t.jpg";
$c_pic_png = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."c_t.png";
$c_pic_gif = $mosConfig_absolute_path."/components/com_marketplace/images/entries/".$mes->id."c_t.gif";
$boolPicFound = 0;
if ( file_exists( $a_pic_jpg)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."a_t.jpg"."' align='center' border='0'>";
$boolPicFound = 1;
}
else {
if ( file_exists( $a_pic_png)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."a_t.png"."' align='center' border='0'>";
$boolPicFound = 1;
}
else {
if ( file_exists( $a_pic_gif)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."a_t.gif"."' align='center' border='0'>";
$boolPicFound = 1;
}
}
}
if ( $boolPicFound == 0) {
if ( file_exists( $b_pic_jpg)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."b_t.jpg"."' align='center' border='0'>";
$boolPicFound = 1;
}
else {
if ( file_exists( $b_pic_png)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."b_t.png"."' align='center' border='0'>";
$boolPicFound = 1;
}
else {
if ( file_exists( $b_pic_gif)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."b_t.gif"."' align='center' border='0'>";
$boolPicFound = 1;
}
}
}
}
if ( $boolPicFound == 0) {
if ( file_exists( $c_pic_jpg)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."c_t.jpg"."' align='center' border='0'>";
}
else {
if ( file_exists( $c_pic_png)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."c_t.png"."' align='center' border='0'>";
}
else {
if ( file_exists( $c_pic_gif)) {
echo "
<img src='".$mosConfig_live_site."/components/com_marketplace/images/entries/".$mes->id."c_t.gif"."' align='center' border='0'>";
}
}
}
}
echo "
<a href=".sefRelToAbs( "index.php?option=com_marketplace&page=show_ad&catid=$mes->category
&adid=$mes->id
&Itemid=$Itemid").">";
if ( strlen($mes->ad_headline)>30){
echo substr( $mes->ad_headline, 0, 27)."...";
}
else {
echo $mes->ad_headline;
}
echo $mes->name." (".$mes->af_date.")";
}
echo "</center>";
?>