How to show multiple results from MySQL Array

Question

Here is my current code:

        $sql = "SELECT * FROM user_posts";
        $result = mysql_query($sql); 
        $row = mysql_fetch_array($result);
        while ($row = mysql_fetch_array($result)) 
        { 
        print $row['message'];
        }

My goal is to show all of the data in that SQL database through an array. But currently, it only shows the latest one and nothing else. How am I able to do this? Thanks!

Greg · Accepted Answer · 2009-10-31 21:59:21Z

2

You should remove this line

$row = mysql_fetch_array($result);

Apart from that it should display every message

answered Oct 31, 2009 at 21:59

Greg

323k55 gold badges378 silver badges338 bronze badges

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

2 Comments

Rohan Over a year ago

Works great! So that means I should not specify the variable before to make it work?

Greg Over a year ago

What you're doing there is effectively removing the first row from the results. Each call to mysql_fetch_array moves on to the next row

BraedenP · Accepted Answer · 2009-10-31 21:58:22Z

0

You're only getting the one row because you overwrite the $row variable with the values from your results array.

$sql = "SELECT * FROM user_posts";
$result = mysql_query($sql); 
while ($info = mysql_fetch_array($result)){ 
    print $info['message'];
}

Change it to something like that.

answered Oct 31, 2009 at 21:58

BraedenP

7,2354 gold badges35 silver badges43 bronze badges

Collectives™ on Stack Overflow

How to show multiple results from MySQL Array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related