-
پاسخ : سوال در مورد mod_section_thumbnails
سلام
من تغییر میدم کد ولی ارور می ده
// 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();
اگه میشه کمک کنید
جهت مشاهده لینک ها باید ثبت نام کنید یا لاگین کنید.
-
-
01-01-2008 10:33 AM
# ADS
تبلیغات در جوملا فارسی
علاقه مندی ها (Bookmarks)