title: PHP: Output data from MySQL columns
body: <p>I wanted to get all the rows in a given column and output them, but my code is just not working:</p>
  
  <pre><code>$result = mysql_query("SELECT Name,Number FROM Users WHERE Customer_ID = 1);
    if (!$result) {
      die("Query to show fields from table failed");
    }
  $row = mysql_fetch_assoc($result);
  
  echo $row['Name'];
  echo $row['Number'];
  
  ^ This code is only displaying the first row, how can I list all the rows? 
  </code></pre>