create array from query

[Anon]

I need to create an array of the id field from a query using this table data

///////////////Table////////////
ROW1 ROW2
ID DATA

1 data
2 data
3 data
4 data
5 data
6 data
7 data
8 data
9 data
10 data
11 data
///////////End Table/////////////

I tried this

$get_data"SELECT id
FROM table
";

$got_data=mysql_query($get_data);

$array=mysql_fetch_array($got_data);

if I output the array I only get 1 result value

print_r($array);

returns 11

How do I create an array from a query?

thanks

[Anon]

OK I figured out how to create an array from a query now I cannot get the result that I want from array_keys

The manual saays that if you use this function with the optional search_value
it will return the key. However I am getting an array as a result???????

$x=Array ( [0] => 24 [1] => 25 [2] => 34 [3] => 35 [4] => 36 [5] => 37 [6] => 38 [7] => 39 [8] => 40 [9] => 41 [10] => 42 [11] => 43 )

array_keys($x, "34")

returns Array ([0]=>2)

I want the key not an array

What am I doing wrong?

[Anon]

it has to return an array because there is a possibility that it may find more than one answer. if you just want the first answer, just do:

$x=Array ( [0] => 24 [1] => 25 [2] => 34 [3] => 35 [4] => 36 [5] => 37 [6] => 38 [7] => 39 [8] => 40 [9] => 41 [10] => 42 [11] => 43 ) ;

$search_result=array_keys($x, "34");

$found_key=$search_result[0];