Re: Query showing all data

Do you still have this issue?

What have you tried to do to solve it?
- try the SQL statement in phpMyAdmin directly using a know value for "eireceiver"!
- try replacing '$matriid' with a known value, ie. that you know is in the database!

Kindly inform us of the result :)
Enjoy, John

On Thursday, 1 October 2015 08:22:07 UTC+3, cakephp-learner wrote:

Hi,

I am fetching a strange problem.

When i am using a custom query like the following one

 $re = $this->Expressinterest->query( "SELECT * FROM expressinterest Where eireceiver = '$matriid' order by id desc limit 0 , 5");

     

It's taking all the data though here is a condition and limit.

Can anyone tell me what's the problem.

Thanks

Zahid

--
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+unsubscribe@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/d/optout.