Mysqli_fetch_array not giving any results

Question

I'm working on a website that uses a lot of database echoing. But the problem is I have used some code that always worked for me before and this time it isn't working at all.

The Code:

<?php
    $result=mysqli_query($mysqli, "SELECT * FROM action ORDER BY gameid ASC");
    while($row = mysqli_fetch_array($result)){
        echo $row['gamename'];
    }
?>

I am not seing any errors.

Does the query give you any results when you run it directly in your db? — Naruto, Apr 03 '15 at 11:21
add `mysqli_query() or die($mysqli->error)` and check whats up — Kevin, Apr 03 '15 at 11:22
$host = "sql305.freezoy.com"; $user = "(or this)"; $pass = "(not giving this)"; $daba = "frzoy_16044062_game"; $mysqli = mysqli_connect($host, $user, $pass, $daba); — Trojan_DC, Apr 03 '15 at 11:37
Try to check the result: `if ($result === FALSE) echo "I got no results for you."; else echo "Well, there is something here.";`. — KIKO Software, Apr 03 '15 at 11:40
Try the 'else' bit. Still nothing? Then you might have a syntax error somewhere. — KIKO Software, Apr 03 '15 at 11:43
im getting nothing out of the original echo but the else KIKO suggested is being displayed — Trojan_DC, Apr 03 '15 at 11:46
Then try to run your query within `sql` or try **error_reporting(E_ALL)** which will show if there's an error — Narendrasingh Sisodia, Apr 03 '15 at 11:50
Within the loop try `print_r($row);` to see what's in the rows, this will only do something if there are rows to display. — KIKO Software, Apr 03 '15 at 12:04
Nothing i even added a 2nd fake game to the db and its doing nothing — Trojan_DC, Apr 03 '15 at 12:07
I guess you mean with the `print_r()`? I'm sorry, I cannot explain it. You've check that it has a result, there's no syntax error, and you should get the two rows in the database. You could still check this with: `echo '['.mysqli_num_rows($result).']';` just after the query and before the loop. — KIKO Software, Apr 03 '15 at 12:16
@Phil No, just stuck in an everlasting rabbit hole. I search one thing and I get hundreds of nonsensical posts that need to be closed, retagged or/and deleted. If you want to help out I appreciate any help I can get. Thanks — Dharman, Jan 19 '21 at 23:05

score -1 · Answer 1 · answered Apr 03 '15 at 12:56

-1

try maybe it helps

$result=mysqli_query($mysqli, "SELECT * FROM action ORDER BY gameid ASC");
$row = mysqli_fetch_array($result)
echo $row['gamename'];

answered Apr 03 '15 at 12:56

Vimal Rai

757
5
6

this did not help im thinking its something wrong with the database – Trojan_DC Apr 03 '15 at 14:02

Mysqli_fetch_array not giving any results

1 Answers1