title: How to store row/column of mysql data in array
body: <p>I want to be able to store (not echo) some data that has been selected from a mysql database in a php array. So far, I have only been able to echo the information, I just want to be able to store it in an array for later use. Here is my code:</p>
  
  <pre><code>$query = "SELECT interests FROM signup WHERE username = '$username'";
  $result = mysql_query($query) or die ("no query");
  while($row = mysql_fetch_array($result))
  {
  echo $row['interests'];
  echo "&lt;br /&gt;";
  }
  </code></pre>