hi cricket,... thank you for your reply,... I have tried it,... and still have no luck,...
$this->User->recursive = 0; $params = $this->params['url']; if (!array_key_exists("find", $params)) { $this->set('users', $this->paginate()); } else { $this->set('users', $this->paginate = array( 'limit' => $limit, 'page' => $page, 'conditions' => array( "MATCH(User.firstname) AGAINST('${q}' IN BOOLEAN MODE)" ), 'contain' => array() ) ); } On Monday, March 4, 2013 4:56:18 PM UTC-8, cricket wrote: > > $this->paginate = array( > 'limit' => $limit, > 'page' => $page, > 'conditions' => array( > "MATCH(User.firstname) AGAINST('${q}' IN BOOLEAN MODE)" > ), > 'contain' => array() > ); > > The $limit & $page vars are gotten from $this->request. And you really > should be escaping the find param with the Sanitize class. The "IN > BOOLEAN MODE"part is of course optional. > > On Mon, Mar 4, 2013 at 6:49 PM, Chris <chri...@yahoo.com <javascript:>> > wrote: > > anyone? > > > > On Sunday, March 3, 2013 4:45:08 PM UTC-8, Chris wrote: > >> > >> hi guys,... can anyone help please,... I'm using cake 1.3 > >> how can I filter search results by user firstname > >> > >> this is my form input: > >> > >> <?php echo $this->Form->create('User', array('action' => 'search')); ?> > >> <?php echo $this->Form->text('find', array('style' => 'width: 60px')) > >> ?> > >> <?php echo $this->Form->end(__('Search', true)); ?> > >> > >> and this is my users_controller.php > >> > >> > >> function search() > >> { > >> > >> $this->User->recursive = 0; > >> $params = $this->params['url']; > >> > >> if (!array_key_exists("find", $params)) { > >> > >> $this->set('users', $this->paginate()); > >> } > >> else > >> { > >> $this->set('users', $this->paginate(array("User.firstname LIKE > >> '{$params['find']}%'"))); > >> } > >> > >> } > >> > >> thanks in advance > >> chris > >> > > -- > > 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+u...@googlegroups.com <javascript:>. > > To post to this group, send email to cake...@googlegroups.com<javascript:>. > > > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.