title: Fatal error: Call to a member function execute() on a non-object in php
body: <p>i dont know whats going one with my code... u use mysqli and when i execute he show this error, some one cam help me pls?</p>
  
  <pre><code>$mysqli = new mysqli($db_host, $db_username, $db_password, $db_name);
  if ($mysqli-&gt;connect_error) {
  die('Error : ('. $mysqli-&gt;connect_errno .') '. $mysqli-&gt;connect_error);
  }
  
  $results = $mysqli-&gt;prepare("SELECT * FROM `imovel` WHERE `finalidade` LIKE $finalidade AND `nquartos` = $nquarto AND `tipoimovel` LIKE $tipoimovel AND `preco` BETWEEN $pmin AND $pmax AND `conselho` LIKE $conselho AND `frequesia` LIKE $frequesia AND `referencia` = $refimovel AND `garagem` = $garagem AND `jardim` = $jardim AND `piscina` = $piscina AND `condominio` = $condominiof AND `elevador` = $elevador AND `vistapreveligiada` = $vistapriv ORDER BY `imovel`.`preco` DESC LIMIT $page_position, $item_per_page");
  $results-&gt;execute(); //Execute prepared Query
  $results-&gt;bind_result($id ,$imagem, $frequesia ,$conselho, $preco); //bind variables to prepared statement
  </code></pre>