[SOLVED] i want an array

[jakatu]

I am trying to get an array of all of the values in a column in a table in my database. can anybody tell me how to do this?

[GingerRobot]

Cycle through the results and add to the array each time you do:

 

<?php
$sql = "SELECT field FROM table";
$result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
$array = array();
while($row = mysql_fetch_assoc($result)){
$array[] = $row['field'];
}
print_r($array);
?>

[jakatu]

Thanks