incorrect result display from database

Question

I have a database table that has 4 records with a column _id that auto increments. When I run a query to get all records, it works but it doesn't echo out all the ids, it only points to the first rows and echos it four times. I am using PHP and MySQLi. Here is my code

Code for querying

$sql = "SELECT * FROM att_table";
$query = $conn->query($sql);
$result = $query->fetch_assoc();

Code for display

do{
    echo result['_id'];
}while($query->fetch_assoc());

It outputs 1111 instead of 1234. Please what is wrong?

please don't use caps and coding/programming language in titles. The tags are enough. I edited your question respectively — Funk Forty Niner
– Funk Forty Niner, Commented Oct 26, 2015 at 22:27

Mark Baker · Accepted Answer · 2015-10-26 22:37:30Z

2

You're fetching each of the 4 results, so it loops the appropriate number of times; but you're only assigning the fetched result to $result once, so that's the only _id value that gets echoed

do{
    echo $result['_id'];
}while($result = $query->fetch_assoc())

edited Oct 26, 2015 at 22:37

answered Oct 26, 2015 at 22:23

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

6 Comments

Ikelie Cyril Over a year ago

Please, how then do I make it work. I have been outputing results that way

Funk Forty Niner Over a year ago

while($query->fetch_assoc()); <= semi-colon is a terminator. No error because that is, believe it or not a valid statement. It must be removed. while($query->fetch_assoc()){...}

Funk Forty Niner Over a year ago

oh and missing a $ for result['_id']; - result is treated as a constant.

Mark Baker Over a year ago

@ITECH-PLANET - No you haven't been doing it that way..... read my answer carefully

Ikelie Cyril Over a year ago

I have checked other codes I have, it same and they are working except this one. :(

|

jarguez01 · Accepted Answer · 2015-10-26 22:50:37Z

0

You also can use a foreach loop :

$sql = "SELECT * FROM att_table";
$query = $conn->query($sql);
$result = $query->fetch_assoc();

foreach($result as $data){
    echo $data['_id'];
}

answered Oct 26, 2015 at 22:50

jarguez01

1841 silver badge7 bronze badges

Collectives™ on Stack Overflow

incorrect result display from database

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related