hi,
i want to join three table in this format .and it is working
properly,but it is giving only fields of listing table.and i want to
get selected fields from all these three tables and i want to use
object of listing table .In this format it is possible or not.and
if it is possible than what will be the pattern of query.
$c=new Criteria();
$c->addJoin(BuilderProjectPeer::OWNER_ID, OwnerPeer::ID);
$c-
>addJoin(ListingPeer::OWNER_ID,BuilderProjectPeer::OWNER_ID);
$c->addJoin(ListingPeer::OWNER_ID,OwnerPeer::ID);
$c->setLimit(5);
$c->addAscendingOrderByColumn('RAND()');//line 47
$checkrecord = ListingPeer::doSelect($c);
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
