mysqli_num_rows returns a value of 0 entries

Asked Feb 21 '21 at 21:35

Active Feb 21 '21 at 21:59

Viewed 252 times

I'm trying to connect to my database to show a row of data from mySQL. I believe I have my data connection set up correctly, as I am able to post data into my database. So I don't believe the error lies in my connection variable $conn. So I am a bit confused in what I could do to try to debug this situation. Any help would be amazing! Thank you!!

Below is my code to retrieve my data from my database:

$sql = "SELECT * FROM `scream` ORDER BY `id` DESC LIMIT 0,1;";

$result = mysqli_query($conn, $sql);

$resultCheck = mysqli_num_rows($result);
    
if ($resultCheck > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo $row['volt'];
    }
}
else{
    echo "no data";
}

edited Feb 21 '21 at 21:40

asked Feb 21 '21 at 21:35

Meike Magdalena Büttner

You are checking of the number of rows is less than 0. – Nigel Ren Feb 21 '21 at 21:37
Oops lol I gotta change that. I was playing with it earlier to see if $resultCheck == 0 and it did. Thanks! – Meike Magdalena Büttner Feb 21 '21 at 21:39
Can you use some other client to execute this query and check how many rows it returns? – Dharman Feb 21 '21 at 21:54
1

The code in your question looks fine. Either that query doesn't return anything or there is another problem. Try to add some proper error messages. See https://stackoverflow.com/a/15320411/2131212 – simon.ro Feb 21 '21 at 21:55

mysqli_num_rows returns a value of 0 entries

0 Answers0