Row list problem

[SkyRanger]

I am having a row list problem I have it working for one select but not others.

 

if ($resulta = $mysqli->query("SELECT * FROM users where userlevel='3' and valid='1' ")) {   ---line 200

   /* determine number of rows result set */
   $row_cnta = $resulta->num_rows;

   printf("%d", $row_cnta);

   /* close result set */
   $resulta->close();
}

/* close connection */
$mysqli->close(); ---line 212

 

This is the error I am getting

Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in /index.php on line 200

Warning: mysqli::close() [mysqli.close]: Couldn't fetch mysqli in /index.php on line 212

 

I am also going to have a resultb and $row_cntab for another count check. with userlevel = '4'

The first one I have is result and $row_cnt and that one works fine.

 

So it display

Userlevel 2 = 3 Users

Userlevel 3 = 5 Users

Userlevel 4 = 0 Users

[Jessica]

You need to check for errors. See the link in my signature.

 

Edit: Actually it sounds like you're not even connected to the database.

[SkyRanger]

Thank you Jessica, once you put your edit post in there I knew exactly what my problem was. I had a $mysqli->close(); before my $resulta ran.