[SOLVED] Transferring data from a Mysql column to a php array...

[captainspi]

Hi there,

 

Is it possible to extract data from a particular mysql column and store it in an array?

 

Thanks in advance...

 

 

 

[GingerRobot]

You'll want something like this:

 

$sql = "SELECT field FROM yourtable";
$result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
$array = array();
while($row = mysql_fetch_row($result)){
$array[] = $row[0];
}
print_r($array);

 

[captainspi]

thanks a lot!