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!

Answer 1

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.

Answer 2

You should remove this line

$row = mysql_fetch_array($result);

Apart from that it should display every message