Hey mohit,
As a better practice never use queries in controller or view files. Always
use a model for all your db queries .
Although you can use queries in both controller and models, i think it
can't be used in view files.
*From controller:*
$output = $this->ModelName->query('SELECT Example FROM USER')
*From Model:*
$output = $this->query('SELECT Example FROM USER')
If any one has solution to use it in view file, pls share it.
Thanks
On Sun, Aug 12, 2012 at 10:23 AM, Yasir Arafat Hasib <[email protected]>wrote:
> Hello follow the url
>
> http://arafats.info/cakephp-custom-query/
>
> Is that ok for you?
> Thanks
>
> On Mon, Aug 6, 2012 at 10:06 PM, mohit kumar <[email protected]> wrote:
>
>> Hi Folks,
>> What is the best way to have custom queries from the databa se. I need to
>> query from one of the pages.
>>
>> *With Best Regards,
>> Mohit Kumar <http://kumarmohit.com>*
>> *+91-9582894570*
>>
>> --
>> 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
>>
>
>
>
> --
> *Thanks & Regards.
>
> -----------------------------------------------------------------------------------------------------------------------------
> Yasir Arafat (Hasib)*
> *Deputy Project Manager, *Software Solutions
> Grameen Solutions
> Contact Information:
> **
> **
> Cell : +8801816 536 901, +880197 *333* 2 888
> Web: http://arafats.info
> <http://arafats.info>
>
> --
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
