How to store row/column of mysql data in array
You could use
$query = "SELECT interests FROM signup WHERE username = '".mysql_real_escape_string($username)."'";$result = mysql_query($query) or die ("no query");$result_array = array();while($row = mysql_fetch_assoc($result)){ $result_array[] = $row;}This will basically store all of the data to the $result_array array.
I've used mysql_fetch_assoc rather than mysql_fetch_array so that the values are mapped to their keys.
I've also included mysql_real_escape_string for protection.
You can "store" it by not accessing it from the result set until you need it, but if you really want to just take it and put it in a variable…
$query = "SELECT interests FROM signup WHERE username = '$username'";$result = mysql_query($query) or die ("no query");$interests = array();while(false !== ($row = mysql_fetch_assoc($result))) { $interests[] = $row;}