Not sure how your getting your *$products *array You could use a
$products = $this->{Model}->find('all',array( 'joins' => array( array( 'table' => 'customers', 'alias' => 'CustomerJoin', 'type' => 'INNER', 'conditions' => array( 'CustomerJoin.customer_id = ProductFamily.customer_id' ) ) ))); Again I dont know the code before or your table names Eric On Monday, June 17, 2013 1:37:38 PM UTC-4, Raks wrote: > > Have added a new Column... but m not able to get a column data from other > model. I want name from customers table in products view.ctp. > > here's the view code: > *<?php > $records = array(); > foreach ($products as $product){ > > $status = ($product['Product']['is_active'] == '1') ? 'Enabled' : > 'Disabled'; > > $records[] = array( > 'Product.model' => array('title' => > $product['Product']['model'], 'id' => $product['Product']['id']), > 'Product.part_num' => > $product['Product']['part_num'], > 'ProductFamily.name' => > $product['ProductFamily']['name'], > // shows customer id.. but want customer name > from customers table according to customer id. > //'Customer.name'=>$product['ProductFamily']['customer_id'], > 'Product.iron_oem' => > ($product['Product']['iron_oem']) ? 'Iron Systems':'Third Party', > 'ProductType.title' => > $product['ProductType']['title'], > 'Product.is_active' => $status, > ); > } > > $data = json_encode($records); > $ret = "{data:" . $data .",\n"; > $ret .= "pageInfo:{totalRowNum:" . $total . "},\n"; > $ret .= "recordType : 'array'}"; > echo $ret; > ?>* > On Friday, June 7, 2013 11:40:19 AM UTC-7, Raks wrote: >> >> Hi, >> >> I Have a piece of code having view, model and controller . I nee dto make >> changes to view only not in the database. >> So how can i do that. Do I need to edit model and controller as well. >> I am new to Cakephp and MVC framework too. >> >> Thanks. >> > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/groups/opt_out.