title: cakephp get data from db
body: <p>I'm new to cakephp how to write below sql query in cakephp</p>
  
  <pre><code>$sql = "SELECT * FROM `user` WHERE `email` = '" . $email . "' AND  `password` = '" . $password . "'";
  
  $result = mysql_query($sql, $connection);
  
  while($fetchdata = mysql_fetch_assoc($result)){
      echo $fetchdata['name'];
  }
  </code></pre>
  
  <p>Please help me
  Thanks</p>