[symfony-users] Re: order by clause in symfony

hi thanks,using this it is working properly On Jul 10, 4:02 pm, Fabrice B <[EMAIL PROTECTED]> wrote: > $c->addAscendingOrderByColumn('RAND()'); > > without the quotes, rand() was executed in PHP. Your goal is to > include it as a string in the SQL clause, so just put quotes aound it. > > F

[symfony-users] Re: order by clause in symfony

$c->addAscendingOrderByColumn('RAND()'); without the quotes, rand() was executed in PHP. Your goal is to include it as a string in the SQL clause, so just put quotes aound it. Fabrice On Jul 10, 7:28 am, kusum <[EMAIL PROTECTED]> wrote: > hi, >      i have already used this > addAscendingOrder

[symfony-users] Re: order by clause in symfony

hi, i have already used this addAscendingOrderByColumn(rand()). but rand() is not a defined column in any table ,so it is giving error. On Jul 9, 5:50 pm, Tom Haskins-Vaughan <[EMAIL PROTECTED]> wrote: > addAscendingOrderByColumn > ^^ > > > > kusum wrote: > > hi all >

[symfony-users] Re: order by clause in symfony

addAscendingOrderByColumn ^^ kusum wrote: > hi all > i want to select random records from listing table using this > format,becoz i want to use > some method of listing class. > > $c=new Criteria(); >$c->addJoin(BuilderProjectPeer::OWNER_ID,