You are correct. My mistake, it would exclude the current year and title.
How about this ? (assuming you also have the id and title of the current
record).
$this->set('neighbors',array(
$this->Build->find('first',array(
'conditions'=>array(
'OR'=>array(
array(
'Build.year_built'=>$build['Build']['year_built'],
'Build.title <='=>$build['Build']['title']
),
'Build.year_build <'=>$build['Build']['year_built']
),
'Build.id <>'=>$build['Build']['id']
),
'order'=>array('Build.year_built desc,Build.title desc, Build.id desc')
)
),
$this->Build->find('first',array(
'conditions'=>array(
'OR'=>array(
array(
'Build.year_built'=>$build['Build']['year_built'],
'Build.title >='=>$build['Build']['title']
),
'Build.year_build >'=>$build['Build']['year_built']
),
'Build.id <>'=>$build['Build']['id']
),
'order'=>array('Build.year_built asc,Build.title asc, Build.id asc')
)
)
)
);
On Tue, Aug 16, 2011 at 8:16 PM, Krissy Masters
<[email protected]>wrote:
> I am thinking the value has to be unique as if it was an id or something
> along those lines. year_built 2008 and doing greater than or less than 2008
> will exclude all other 2008 years.****
>
> ** **
>
> Still I will give your code a go and see what happens.****
>
> ** **
>
> Thanks****
>
> ** **
>
> K****
>
> ** **
>
> *From:* [email protected] [mailto:[email protected]] *On
> Behalf Of *Teddy Zeenny
> *Sent:* Tuesday, August 16, 2011 2:31 PM
>
> *To:* [email protected]
> *Subject:* Re: Neighbors Help****
>
> ** **
>
> Well I'm not sure if you can do it with neighbors...****
>
> ** **
>
> This would probably work though ..****
>
> ** **
>
> $this->set('neighbors',array(****
>
>
> $this->Build->find('first',array(****
>
>
> 'conditions'=>array(****
>
>
> 'Build.year_built < '=>$build['Build']['year_built']****
>
>
> ),****
>
>
> 'order'=>array('Build.year_built desc,Build.title desc')****
>
>
> )****
>
>
> ),****
>
>
> $this->Build->find('first',array(****
>
>
> 'conditions'=>array(****
>
>
> 'Build.year_built > '=>$build['Build']['year_built']****
>
>
> ),****
>
>
> 'order'=>array('Build.year_built asc,Build.title asc')****
>
>
> )****
>
>
> )****
>
>
> ) ****
>
> ****
>
> );****
>
> ** **
>
> On Tue, Aug 16, 2011 at 7:24 PM, Krissy Masters <
> [email protected]> wrote:****
>
> Yeah the plural was typo, but the A,B,C is representing "title" field which
> could be anything entered as a title by the user.****
>
> ****
>
> *From:* [email protected] [mailto:[email protected]] *On
> Behalf Of *Teddy Zeenny
> *Sent:* Tuesday, August 16, 2011 1:11 PM
> *To:* [email protected]
> *Subject:* Re: Neighbors Help****
>
> ****
>
> What is the letters' field name ? (ie. A, B...)****
>
> ****
>
> PS: I think you mean $this->Build->find , not $this->Builds->find****
>
> On Tue, Aug 16, 2011 at 6:31 PM, Krissy Masters <
> [email protected]> wrote:****
>
> I am trying to get my neighbors query based in my 'year_built' value (2001
> to 2011 as values) and placed in alphabetical order****
>
> ****
>
> So if you were viewing A 2001 next would be possibly B 2001 with prev null
> ****
>
> So if listed would appear like****
>
> ****
>
> A 2001****
>
> B2001****
>
> D 2002****
>
> A 2003****
>
> G2005****
>
> Z2005****
>
> D2006****
>
> L2007****
>
> And so on so they are grouped in years and sorted alphabetically.****
>
> ****
>
> I have $this->set('neighbors',$this->Builds->find(****
>
>
> 'neighbors', array('field' => 'year_built', 'value' =>
> $build['Build']['year_built'], ****
>
>
> 'conditions' => array('published' => 1))));****
>
> ****
>
> Any help would be great.****
>
> ****
>
> Thanks****
>
> ****
>
> ****
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php****
>
> ****
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php****
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php****
>
> ** **
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php****
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php
>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
