Object of class mysqli_result could not be converted to int

[bravo14]

Hi all

 

i am using the code below, but am getting the error

 

Object of class mysqli_result could not be converted to int

 

 

<?php
  $sql="SELECT lng,lng_prefix FROM tbl_languages where active = 1";
  $result=mysqli_query($dbConn, $sql)or die(mysqli_error($dbConn)); //problem line
  if(mysqli_num_rows($result==1)){
      ?>

 

The code continues with what I want to happen based on the result.

 

What does the error mean and how do I fix it?

[maxxd]

You've got your end parenthesis in the wrong spot. change

if(mysqli_num_rows($result==1)){

to

if(mysqli_num_rows($result)==1){

and it should work.

[kicken]

Your closing parenthesis for the function call is in the wrong spot. You're trying to call mysqli_num_rows on the result of the $result==1 comparison.

[hansford]

Without correct parenthesis, you're code is being in interpreted as trying to cast the result set to an integer.