mysqli_num_rows() expects parameter 1 to be mysqli_result, array given

Question

I've been trying to look deep into the script, but I still can't find the problem. here's the script

global $con;
$a= "SELECT id_list FROM list ORDER BY id_list";
$b = mysqli_query($con, $a);
$c=  mysqli_fetch_assoc($b);        
    if(mysqli_num_rows($c)==0){
        echo'0';
    }else{
        echo '1';
    }

the error that appear is

mysqli_num_rows() expects parameter 1 to be mysqli_result, array given

what is the code in your variable $con? – Adhan Timothy Younes Feb 21 '17 at 04:50 — Adhan Timothy Younes, Feb 21 '17 at 04:50
@AdhanTimothyYounes mysqli_connect($host,$user,$pass,$db); – ゆにたどうえ Feb 21 '17 at 04:53 — ゆにたどうえ, Feb 21 '17 at 04:53

score 4 · Answer 1 · edited Apr 28 '20 at 23:25

4

You have to use mysqli_result onject as a parameter to mysqli_num_rows() so try:

mysqli_num_rows($b)

read manual here link

edited Apr 28 '20 at 23:25

Dharman

30,962
25
85
135

answered Feb 21 '17 at 04:58

gaurav

1,281
1
13
25

mysqli_num_rows() expects parameter 1 to be mysqli_result, array given

1 Answers1

Related