سلام
من تغییر میدم کد ولی ارور می ده
// query records
$query = "SELECT a.*, cc.image AS image"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
. "\n WHERE a.state = '1'"
. "\n AND sectionid IN (". $sections. ""
. "\n AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now' )"
. "\n AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now' )"
. "\n ORDER BY publish_up DESC"
. "\nlimit $skip," . $count
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
اینم غییر دادن کد ولی نمی شه
// DESC records
$DESC = "SELECT a.*, cc.image AS image"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
. "\n WHERE a.state = '1'"
. "\n AND sectionid IN (". $sections. ""
. "\n AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now' )"
. "\n AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now' )"
. "\n ORDER BY publish_up DESC"
. "\nlimit $skip," . $count
;
$database->setDESC( $DESC );
$rows = $database->loadObjectList();
اگه میشه کمک کنید




"

علاقه مندی ها (Bookmarks)