<?php
/**
* este es mi intento por conectarme a la base de datos
*/
?>
<?php
global $database;
$Itemid = intval( mosGetParam( $_REQUEST, 'Itemid', '0' ) );
$database->setQuery("SELECT a.id, a.category, a.ad_headline, a.ad_condition, a.ad_price, 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 ");
?>
y esto es lo que sale en pantalla cuando lo pruebo en internet
