mysql_fetch_array

[c_pattle]

Hi.  I just have a quick question.  If I perform a mysql query like the one below that returns all of the rows in a table.  How do I then add all of this data into an array.  If I use the following code bellow the variable $array will only contain the first row of the table. 

 

$rs = mysql_query($query, $conn);
$array = mysql_fetch_array ($rs);

[jcbones]

Simple answer.

 

$rs = mysql_query($query, $conn);
while($row = mysql_fetch_array ($rs)) {  //loop through the data,
  $array[] = $row; //and collect the rows.
}