How can i convert this simple query to cakephp ?

Question

Hi , actually i have 1 query but i am unable to convert it into cakephp query format.

$result = "select * from esl_userresults,esl_lyrics where esl_userresults.esl_songID = esl_lyrics.id and esl_lyrics.song_name like '%".$esl_keyword."%'" ;

when i convert this query into cakephp it gives error like
esl_userresults.esl_songID unknown column.

Please help

thanks

Answer 1

You asked the same question yesterday: http://stackoverflow.com/questions/3092944/converting-simple-query-to-cake-query

Answer 2

You can execute any query using:

<?php 
   function some_controller_name()
   {
     $query_to_execute = 'SELECT * .....';
     $results = $this->ModelName->query($query_to_execute);
     $this->set('results', $results);
   }
?>

Hope this helps