title: mysql query convert to mysqli
body: <p>I am using the below query with the server setting as mysql in Joomla quite successfully, but can't get it run using the settings as mysqli in joomla Fabrik extension.</p>
  
  <pre><code>$db = JFactory::getDbo();
  $query = $db-&gt;getQuery(true);
  $sql = mysql_query("SELECT first_name,mobile FROM students WHERE
  DAY(dob) = DAY(CURDATE()) AND
  MONTH(dob) = MONTH(CURDATE())");
  
  while($row = mysql_fetch_array($sql)) {
  //mycode- to - send SMS
      }
  </code></pre>
  
  <p>I have modified the above code for mysqli as below with no success:</p>
  
  <pre><code>$db = JFactory::getDbo();
  $query = $db-&gt;getQuery(true);
  $sql = mysqli_query("SELECT first_name,mobile FROM students WHERE
  DAY(dob) = DAY(CURDATE()) AND
  MONTH(dob) = MONTH(CURDATE())");
  
  while($row = mysqli_fetch_array($sql)) {
  //mycode- to - send SMS
      }
  </code></pre>
  
  <p>What other changes I need to make in the above query so that I can use it using mysqli settings.</p>
  
  <p>Thanks.</p>