dede表前缀不定时,查询表#@__archives

 $query = "SELECT arc.*,tp.typedir,tp.typename,
              tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
          FROM `#@__archives` arc LEFT JOIN `#@__arctype` tp ON tp.id=arc.typeid
          WHERE arc.id in($ids) ORDER BY arc.{$order} $orderway ";
posted @ 2017-07-13 14:35  码农编程进阶笔记  阅读(24)  评论(0编辑  收藏  举报
返回顶部 有事您Q我