Inserting data into an array during while

[otem]

Hello, I'm grabbing content out of a database table, and I'm trying to input it into an array.

Right now, my code will output five records onto the screen. What I would like instead would be to output this content into one array.

How might I do that?

Thanks

$query=mysql_query("SELECT content FROM database LIMIT 5");
while($row=mysql_fetch_array($query)) echo $row["content"];

[cameraman]

while($row=mysql_fetch_array($query)) {
$data[] = $row['content'];
echo $row["content"];
}

[otem]

Thanks for the reply!

I also found that the following script works too!

$array=array();
$query=mysql_query("SELECT content FROM database LIMIT 5");
while($row=mysql_fetch_array($query)) array_push($array,$row["content"]);

[eelixduppy]

Just a random tip for the day...

I have observed that using this syntax:

$array[] = $row['content']; 

is about twice as fast (on average) than using this:

array_push($array,$row["content"]); 

when dealing with large arrays. :)