Inserting returned row data into a new array

[nbennett]

Hi - I'm still pretty green in the world(s) of MySQL, but I'm wondering how I can create an array out of data being returned out of a multiple row query.

I essentially want a single column values of the database put into an array, instead of row values.

something to the effect of:

$returns=mysql_query("SELECT columnData >FROM mytable");_

while($cols=mysql_fetch_array($returns))
{

______print_r($cols);
}

but instead of 'print_r', something like build_array (made that one up).

thanks for any pointers.

[LordShryku]

$array = array();
while($cols = mysql_fetch_array($returns)) {
   $array[] = $cols;
}

[nbennett]

thanks - that got me most of the way there. the only bug is that the mysql_fetch_row function returns an array, so i had an array of arrays of one element. I had to swap out the mysql_fetch_row for the mysql_fetch_object function, and it worked great.

thanks