Salve ragazzi..avrei bisogno di vedere la news di ordine 1 in una cella a parte.. ho inserito questo:
$query = "SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,"
. "\n a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,"
. "\n CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__sections AS s ON a.sectionid = s.id"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. "\n AND a.ordering = 1 ORDER BY $order_pri $order_sec";
echo $query;
$database->setQuery( $query);
$rows = $database->loadObjectList();
if( count( $rows ) ) {
foreach ( $rows as $row ) {
echo $row ->id." - ".$row ->title."<br />";
}
}
e mi da il risultato voluto..solo che manca formattazione ecc..cioè non vedo immagine link e scritte formattate come al resto del cms..come gestisco il result della query?
