某渣

某渣

这家伙有点懒，还没写个性签名！

私信
  • 财富值159
  • 威望值0
  • 总积分199

个人信息

某渣

全部动态
  • 2015-05-10 已签到
    连续签到3天，获得了15个金钱
    2015-05-10 09:55
  • 2015-05-09 已签到
    连续签到2天，获得了10个金钱
    2015-05-09 07:55
  • 回复了 的回答
    Yii::app()->db->createCommand('select * from ( select a.SHOP_ID,b.TITLE,b.modified_time from EC_SHOP a join EC_SHOP_POST b on a.SHOP_ID = b.SHOP_ID ORDER BY b.modified_time DESC ) as t group by t.SHOP_ID')->queryAll();

    没事

    2015-05-08 22:06查看
  • 回复了 的回答
    Yii::app()->db->createCommand('select * from ( select a.SHOP_ID,b.TITLE,b.modified_time from EC_SHOP a join EC_SHOP_POST b on a.SHOP_ID = b.SHOP_ID ORDER BY b.modified_time DESC ) as t group by t.SHOP_ID')->queryAll();

    你说的有问题如果嵌套查询应该

    $command->Yii::app()->db->createCommand('select * from (select a.SHOP_ID,b.TITLE,b.modified_time from EC_SHOP a join EC_SHOP_POST b on a.SHOP_ID = b.SHOP_ID   ORDER BY b.modified_time DESC) as t group by t.SHOP_ID');
$command->queryAll();
    2015-05-08 18:13查看
  • 回复了 的回答
    Yii::app()->db->createCommand('select * from ( select a.SHOP_ID,b.TITLE,b.modified_time from EC_SHOP a join EC_SHOP_POST b on a.SHOP_ID = b.SHOP_ID ORDER BY b.modified_time DESC ) as t group by t.SHOP_ID')->queryAll();

    好的，谢谢

    2015-05-08 17:29查看
  • 回复了 的回答

    Yii::app()->db->createCommand()不就是用来发送你写的原生SQL语句的吗？

    这么写会报错写到里面会报错.......

    2015-05-08 17:10查看
  • 回复了 的回答
    Yii::app()->db->createCommand('select * from ( select a.SHOP_ID,b.TITLE,b.modified_time from EC_SHOP a join EC_SHOP_POST b on a.SHOP_ID = b.SHOP_ID ORDER BY b.modified_time DESC ) as t group by t.SHOP_ID')->queryAll();

    SQL是没有问题的，可以运行

    2015-05-08 17:07查看
  • 回复了 的回答
    Yii::app()->db->createCommand('select * from ( select a.SHOP_ID,b.TITLE,b.modified_time from EC_SHOP a join EC_SHOP_POST b on a.SHOP_ID = b.SHOP_ID ORDER BY b.modified_time DESC ) as t group by t.SHOP_ID')->queryAll();

    报错
    CDbCommand 无法执行 SQL 语句: SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty. The SQL statement executed was:

    2015-05-08 17:01查看
  • 提出了问题
    Yii 嵌套查询
    2015-05-08 16:48回答(2)•浏览(5637)
  • 2015-05-08 已签到
    连续签到1天，获得了5个金钱
    2015-05-08 16:46
助理 等级规则
199/200
资料完整度
20/100
用户活跃度
0/100

Ta的关注

0

Ta的粉丝

2

Ta的访客

6