title: Why would a script not like using MySQLi but is fine with MySQL?
body: <p>I'm having some issues using mysqli to execute a script with SELECT,DELETE,INSERT and UPDATE querys. They work when using norm mysql such as mysql_connect but im getting strange results when using mysqli. It works fine with a lot of the SELECT querys in other scripts but when it comes to some admin stuff it messes up.</p>
  
  <p>Its difficult to explain without attaching the whole script.</p>
  
  <p>This is the function for modifying...</p>
  
  <pre><code>
  function database_queryModify($sql,&$insertId)
    {
      global $databaseServer;
      global $databaseName;
      global $databaseUsername;
      global $databasePassword;
      global $databaseDebugMode;
  
      $link = @mysql_connect($databaseServer,$databaseUsername,$databasePassword);
  
      @mysql_select_db($databaseName,$link);
  
      $result = mysql_query($sql,$link);
  
      if (!$result && $databaseDebugMode)
      {
        print "[".$sql."][".mysql_error()."]";
      }
  
      $insertId = mysql_insert_id();
  
      return mysql_affected_rows();
    }</code></pre>
  
  <p>and heres what I changed it to for mysqli</p>
  
  <pre><code>
  function database_queryModify($sql,&$insertId)
    {
      global $databaseServer;
      global $databaseName;
      global $dbUser_feedadmin;
      global $dbUser_feedadmin_pw;
      global $databaseDebugMode;
  
      $link = @mysqli_connect($databaseServer,$dbUser_feedadmin,$dbUser_feedadmin_pw,$databaseName);
      $result = mysqli_query($link, $sql);
  
      if (!$result && $databaseDebugMode)
      {
        print "[".$sql."][".mysqli_error()."]";
      }
      $insertId = mysqli_insert_id();
      return mysqli_affected_rows();
    }
  </code></pre>
  
  <p>Does that look right?</p>
  
  <p>It isn't actually producing an error but its not functioning in the same way as when using mysql. any ideas?</p>