Return certain column from every row in a MySQL table in an array in PHP

Question

So let's say this is the hierarchy of my database in MySQL.

Database: Example
  Table: Test
    Row 1
      Column 1 ("one"): Whatever
      Column 2 ("two"): Something
      Column 3 ("three"): Test
    Row 2
      Column 1  ("one"): Blah
      Column 2  ("two"): Testing
      Column 3  ("three"): Yup

How can I return an array that has the values of the one columns?

The array would look like this:

Array ( [0] => Whatever [1] => Blah )

Answer 1

$query = "SELECT column1 FROM test";
$result = mysql_query($query);
$numRows = mysql_num_rows($result); // should be 2

while($row = mysql_fetch_array($result)) {
  $row[0]; // data from column
}

Answer 2

Might be issue with the spaces. If there are spaces in column name use back quotes e.g

 select `Column 1` from tablename;

I am not sure your example depicts your actual problem :(

Answer 3

I think its simple.

select Column 1 From tablename;