Jump to content
acctman

expects parameter 1 to be mysqli_result

Recommended Posts

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()."','$
   } 

Share this post


Link to post
Share on other sites

$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 by Barand

Share this post


Link to post
Share on other sites

$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?

Share this post


Link to post
Share on other sites

$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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.