many-to-many order

[Tim Sawyer]

How do I add an order to this query?


         require_once "SlocsTable.php";
         $slocsTable= new SlocsTable();
         $slocsRowset = $slocsTable->find($id);
         $sloc = $slocsRowset->current();

         #require_once "SansTable.php";
         #$sansTable = new SansTable();
         #$select = $sansTable->select()->order('san_name');

         $sansRowset = $sloc->findManyToManyRowset('SansTable',  
'SlocsSansTable', 'Sloc');


My commented attempts did not work. TIA, very much.
--
Tim
:wq

[Jack Sleight]

This should do it:

$sansRowset = $sloc->findManyToManyRowset('SansTable', 'SlocsSansTable',
'Sloc', null, $slocTable->select()->order('san_name'));
--
Jack