doulu1914 2015-07-16 08:45
浏览 29
已采纳

PHP。 Zend DB适配器

There is gallery on my site, and every picture has own tag. All of the tags are sorting chaotically. I want to sort them by value of field "index" in galleryTagsTable.

When it's show chaotically code was:

foreach ($_tags as $item) {
    $select = new Select();
    $tags[] = $this->getGalleryTagsTable()->fetchAll($select->where(array('id' => $item)));
}

To make sorting by field "index", I created this field and wrote this code:

foreach ($_tags as $item) {
    $select = new Select();
    $tags[] = $this->getGalleryTagsTable()->fetchAll($select->where(array('id' => $item))->order('index DESC'));
}

but it still doesn't work. I tried to write without 'DESC' & tried to sort by 'id'. None of these work.

  • 写回答

1条回答 默认 最新

  • douci2516 2015-07-16 14:09
    关注

    Supposing that your Select() object is some kind of extended object of Zend_Db_Select, I think this is not working as you expected because that's not the correct syntax for the where clause. Correct one would be:

    $select->where('id = ?', $item)
           ->order('index DESC');
    

    Note the '?' wildcard on the expression. This is made in case you don't want it to be an equals but a greater than, or other comparison clauses such as RLIKE. And please, note also that it's not an array.

    Probably your where clause wasn't working as intended and that was causing the problems on the order of your tags since they were not grouped by id.

    I hope this helps.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题