What do I change to this to get "sname" in my while loop? <?php class Order extends AppModel { var $name = 'Order';
var $belongsTo = array('Customer' => array('className' => 'Customer', 'conditions' => '', 'order' => 'name ASC', 'limit' => '', 'foreignKey' => 'customer_id', 'dependent' => true, 'exclusive' => false, 'finderQuery' => '' ), 'Supplier' => array('className' => 'Supplier', 'conditions' => '', 'order' => 'sname ASC', 'limit' => '', 'foreignKey' => 'supplier_id', 'dependent' => true, 'exclusive' => false, 'finderQuery' => '' ) ); } ?> function index() { $criteria=NULL; list($order,$limit,$page) = $this->Pagination- >init($criteria); // Added $data = $this->Order->findAll($criteria, NULL, $order, $limit, $page); // Extra parameters added $this->set('data',$data); } $pagination->setPaging($paging); // Initialize the pagination variables $th = array ( $pagination->sortBy('id'), $pagination->sortBy('dateoforder'), $pagination->sortBy('eta'), $pagination->sortBy('sname'), $pagination->sortBy('customer_id'), $pagination->sortBy('total'), $pagination->sortBy('ref'), $pagination->sortBy(' ') ); // Generate the pagination sort links echo $html->tableHeaders($th); // Create the table headers with sort links if desired foreach ($data as $output) { $tr = array ( $html->link($output['Order']['ordernum'], "/Orders/Edit/ {$output['Order']['id']}"), $output['Order']['id'], $output['Order']['eta'], $output['Order']['sname'], $html->link("Delete", "/Orders/Delete/{$output['Order'] ['id']}",null,'Are you sure?') ); echo $html- >tableCells($tr,array('class'=>'altRow'),array('class'=>'evenRow')); } I tried playing around with findall but Im not sure how to print it by output and orderby? L --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---