putting a mysql column into an array

[tck]

I am drawing a blank on this one. I need to take all of the data in one column of a mysql table and put into an array.

Thanks for the help

[drag0n]

lookup function, mysql_fetch_array on php.net

[jweissig]

hello,

try something like this

$sql = "SELECT column_from_db FROM database_table";
$result = $site_db->query($sql);

if (!$result) {
  echo 'No Results found..';
  exit;
}
while ($row = $site_db->fetch_array($result)) {
  $column[$row['column_from_db']];
}
$site_db->free_result();

You have to have $site_db = your database handler, you know the statement where you pass it the username, password, hostname, and database name.

Hope this helps,
- Justin