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+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. For more options, visit https://groups.google.com/d/optout.