title: Changing this from MySQL to MySQLi?
body: <p>I've decided to switch to MySQLi, because some people have told me it's more secure.. What I'm really confused about, is the new extensions. I tried just added 'i' after every mysql, but that gave me a crap load of errors. I looked up in the PHP manual why that was happening and there was a whole bunch of other functions.. I honestly can't figure out how to convert. Can you help me out? </p>
  
  <pre><code>include("dbinfo.php");
  mysql_connect($c_host,$c_username,$c_password);
  @mysql_select_db($c_database) or die(mysql_error());
  $mycon = new mysqli($c_host, $c_username, $c_password, $c_database);
  $query="SELECT * FROM users WHERE username='" .$_COOKIE['username']. "'";
  $result=mysql_query($query) or die(mysql_error());
  $num=mysql_numrows($result);
  $username=mysql_result($result,$i,"username");
  </code></pre>