acctman Posted September 2, 2015 Share Posted September 2, 2015 I'm trying to resolve these to mysqli update changes. I've rewritten the statements a few times but just keep receiving errors. Can some show me how to rewrite the mysqli_result() correctly. - thanks Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in $loadSession = mysqli_query($con, "SELECT smo.* FROM social_members_online AS smo LEFT JOIN social_members AS sm ON smo.o_id=sm.m_id WHERE smo.o_id='".session_id()."' ...); $result = mysqli_fetch_assoc($loadSession); // Check the Result if (mysqli_num_rows($loadSession) == 0) { // User has no session, create one mysqli_query($con, "INSERT INTO social_members_online (o_id,o_start,o_last,o_session_id,o_ip) VALUES (".(int)$_SESSION['userid'].", ".time().",".time().",'".session_id()."','$ } Quote Link to comment Share on other sites More sharing options...
Solution Barand Posted September 2, 2015 Solution Share Posted September 2, 2015 (edited) $loadSession will contain either a valid result object or, if the query failed, the boolean value "false" Your query failed - check the value given by $con->error Edited September 2, 2015 by Barand Quote Link to comment Share on other sites More sharing options...
acctman Posted September 2, 2015 Author Share Posted September 2, 2015 $loadSession will contain either a valid result object or, if the query failed, the boolean value "false" Your query failed - check the value given by $con->error but I have if (mysqli_num_rows($loadSession) == 0) { to had if it's 0 (false). Am I missing something? Quote Link to comment Share on other sites More sharing options...
acctman Posted September 2, 2015 Author Share Posted September 2, 2015 $loadSession will contain either a valid result object or, if the query failed, the boolean value "false" Your query failed - check the value given by $con->error after re-reading your response I found the problem. I did not have the database in $con... the error checked worked. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.