Mysqli num rows and mysqli fetch array issue [duplicate]

Question

I try to google it but, i really dont understand what is the problem with this query. Here is code

include_once("includes/db_connection.php");
//Upit za prikaz pitanja!
$listaPitanja = "";
$sql = "SELECT id, username, question FROM useroptions ORDER BY DESC";
$user_query = mysqli_query($db_connection, $sql);
$pitanjaCount = mysqli_num_rows($user_query); //line 8
if ($pitanjaCount > 0) {
while ($row = mysqli_fetch_array($sql))  { //line 10
$id = $row['id'];
$question = $row['question'];
$username = $row['username'];
$listaPitanja .= '<div id="brojOdgovora">'.$id.'</div>
            <div id="tekstPitanja"><h3>'.$question.'</h3></div>
            <div id="userPitanja"><h6>'.$username.'</h6></div>';
    } 
} else {
$listaPitanja = "There is no inserted questions!";
}

This query gives me nothing. Just this error mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in something on line 8, and if i delete ORDER BY DESC there is some error on line 10? Sorry if it repeated, but i have no idea to solve this!! Thank you!

Try the solution from Maarten van Middelaar.

segarci
– segarci

2014-03-12 22:45:24 +00:00
Commented Mar 12, 2014 at 22:45 — segarci
– segarci, Commented Mar 12, 2014 at 22:45

segarci · Accepted Answer · 2014-03-12 22:34:10Z

2

Your SQL statement has no ORDER column:

$sql = "SELECT id, username, question FROM useroptions ORDER BY DESC";

Change it with the correct column name:

$sql = "SELECT id, username, question FROM useroptions ORDER BY column_name DESC";

Probably, mysqli_query is returning false instead of mysqli_result object.

answered Mar 12, 2014 at 22:34

segarci

7371 gold badge11 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maarten van Middelaar · Accepted Answer · 2014-03-12 22:38:02Z

1

To add segarci,

$row = mysqli_fetch_array($sql)

should be

$row = mysqli_fetch_array($user_query)

answered Mar 12, 2014 at 22:38

Maarten van Middelaar

1,72110 silver badges15 bronze badges

Collectives™ on Stack Overflow

Mysqli num rows and mysqli fetch array issue [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related