脚本宝典收集整理的这篇文章主要介绍了php – 内在的教义子查询，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。
select t.won,e.etot,s.username,s.country,r.points,r.rank From sf_Guard_user s INNER JOIN marks r ON r.user_id = s.id inner join (select t.user_id,count(t.user_id)as won from topPEr t group by t.user_id) t on t.user_id=s.id inner join (select e.user_id,count(e.user_id)as etot from exams e group by e.user_id) e on e.user_id=s.id ORDER BY r.rank asc
我在sfGuardUserTable类中写了原则代码：
$q= $this->createQuery('u');
$wq =$q->createSubquery()
->select('t.user_id,count(t.user_id) won')
->from('Topper t')
->groupBy('t.user_id');
$dq = $q->createSubquery()
->select('e.user_id,count(e.user_id) etot')
->from('Exams d')
->groupBy('d.user_id');
$q->select(' t1.won,e1.dtot,u.username,u.country,r.rank')
->innerJoin ('u.Marks r ON r.user_id = u.id')
->innerJoin ('u.('.$wq->getDql().') t1 on t1.user_id=u.id')
->innerJoin ('u.'.$dq->getDql().' e1 on e1.user_id=u.id')
->orderBy('r.rank asc');
//echo $q->getsql();
return $q;
它是给错误找不到类SELECT :(请帮助我,谢谢提前.
$q = new Doctrine_Rawsql(); $q->select('{t.won},{e.etot},{s.username},{s.country},{r.marks},{r.ranks}'); $q->from('sf_Guard_User s INNER JOIN marks r ON r.user_id = s.id inner join (select t.id,t.user_id,count(t.user_id)as won from topper t group by t.user_id) t on t.user_id=s.id inner join (select d.id,d.user_id,count(e.user_id)as etot from exams e group by e.user_id) e on e.user_id=s.id ORDER BY r.rank asc'); $q->addcomponent('s','sfGuardUser s'); $q->addComponent('r','s.Marks r'); $q->addComponent('t','s.Topper t'); $q->addComponent('e','s.Exams e'); return $q;
为更多的帮助read it.
以上是脚本宝典为你收集整理的php – 内在的教义子查询全部内容，希望文章能够帮你解决php – 内在的教义子查询所遇到的问题。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。