Saturday, October 31, 2009

Re: Browse By Letter (a php question)

Hi,

> As of right now, I do it in a really bad way.. I have a loop that goes
> from A->Z which SELECT COUNTS each letter and throws everything in one
> array.
>
> What's a better way to do that? Instead of have 26 queries?

You search for "LIKE {letter}%", eg:

public function search($letter='a')
{
$conditions = array('Page.name LIKE'=>$letter.'%');
$this->data = $this->Page->find('all', array(
'conditions'=>$conditions
));
$this->autoRender = 0;
}

hth

Jon

--
jon bennett - www.jben.net - blog.jben.net

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

No comments: