php mysqli query not returning all the rows in a table

Question

I have a MySQL table called comments that contains a column called vz_comments and basically I want to show all the comments related to the character_id. However my current query only shows 1 comment but when I put the statement into phpmyadmin it shows all the comments.

$comments_query = $conn->query("SELECT vz_comments FROM comments WHERE character_id='$comment_id'");

$comments_array = $comments_query->fetch_array();

echo $comments_array['vz_comments'];

You are only fetching one row. If you want all rows, use fetch_all(). — jeroen
– jeroen, Commented Feb 6, 2016 at 12:15
$comments_array = $comments_query->fetch_all(MYSQLI_ASSOC) — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Feb 6, 2016 at 12:21

Mureinik · Accepted Answer · 2016-02-06 12:20:05Z

2

fetch_array fetches a single row as an array of its columns (either numeric or associative, depending on the parameters. By default, MYSQLI_BOTH is used, retrieving an array with attributes of both styles.

To fetch the entire result in a single call, you should use fetch_all instead.

answered Feb 6, 2016 at 12:20

Mureinik

316k54 gold badges401 silver badges405 bronze badges

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

Collectives™ on Stack Overflow

php mysqli query not returning all the rows in a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related