Return results as Array

[willpower]

Databas with 3 fields id, name ,active

 

rows are

 

1----option1----1

2----option2----1

3----option3----1

 

How can i extract all options into a single array so as

 

$results=array('option1','option2','option3');

 

 

[genericnumber1]

$query = 'SELECT * FROM table';
$results = mysql_query($query);

$array = array();
while($row = mysql_fetch_assoc($results))
{
      $array[] = $row['colname'];
}