title: problems converting my php script to mysqli
body: <p>i recently did lots of changes to a site i was working on and went thru the entire project replacing the old mysql_ methods of interacting with the database. in this certain script im having trouble getting it to work the same.</p>
  
  <p>the old code is </p>
  
  <pre><code>$checkinfo = mysql_query("SELECT * FROM `myusers` WHERE `userid` = '$uid' LIMIT 1") or die(mysql_error());
  
  if(mysql_num_rows($checkinfo) &lt; 1){ //log and die if user isnt in db
    die("Incident has been logged!"); }
  
  $myinfo = mysql_fetch_assoc($checkinfo);    
  </code></pre>
  
  <p>and my new code is </p>
  
  <pre><code>$checkinfo = $mysqli-&gt;query("SELECT * FROM `myusers` WHERE `userid` = '$uid' LIMIT 1") or die('Error : ('. $mysqli-&gt;errno .') '. $mysqli-&gt;error);  
  
  if($checkinfo-&gt;fetch_row() &lt; 1){
      die("Incident has been logged!"); } 
  
  $myinfo = $checkinfo-&gt;fetch_assoc();
  </code></pre>
  
  <p>now its simply not setting my array for the rest of the code... please point out my stupidity! thanks</p>