Cakephp, SQL prepared statement not returning proper results?

$conditions = array(); // it's a postback, so the key should exist if($this->data'Listing''listing_countyid'! == '') { $conditions'listing_countryid' = $this->data'Listing''listing_countyid'; } if($this->data'Listing''listing_area'! == '') { $conditions'listing_area' = $this->data'Listing''listing_area'; } if($this->data'Listing''listing_neighborhood'!

== '') { $conditions'listing_neighborhood' = $this->data'Listing''listing_neighborhood'; } if($this->data'Listing''min_price'! == '') { $conditions'listing_listprice >=' = $this->data'Listing''min_price'; } if($this->data'Listing''max_price'! == '') { $conditions'listing_listprice data'Listing''max_price'; } I'm sure you can see what I'm doing and you should be able to complete this for the other params.

Then you can assign $conditions to the conditions key in your find function call $listings = $this->Idx->find('all', array( 'conditions' => $conditions )) I considered assigning the $condtions in a loop, but that could be a bit complicated with min and max values.

$conditions = array(); // it's a postback, so the key should exist if($this->data'Listing''listing_countyid'! == '') { $conditions'listing_countryid' = $this->data'Listing''listing_countyid'; } if($this->data'Listing''listing_area'! == '') { $conditions'listing_area' = $this->data'Listing''listing_area'; } if($this->data'Listing''listing_neighborhood'!

== '') { $conditions'listing_neighborhood' = $this->data'Listing''listing_neighborhood'; } if($this->data'Listing''min_price'! == '') { $conditions'listing_listprice >=' = $this->data'Listing''min_price'; } if($this->data'Listing''max_price'! == '') { $conditions'listing_listprice data'Listing''max_price'; } I'm sure you can see what I'm doing and you should be able to complete this for the other params.

Then you can assign $conditions to the conditions key in your find function call. $listings = $this->Idx->find('all', array( 'conditions' => $conditions )); I considered assigning the $condtions in a loop, but that could be a bit complicated with min and max values.

Works thanks, I had the thought of passing an array as the condition also, but I was thinking of pushing the values to the array. – Andre Dublin Aug 10 at 21:39.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.