Putting All Results Into A Variable

[webmasternovis]

Hi all,

I want to put everything under a certain column in a table into one variable.

So say if I had one column called "text", and there were two rows. I'd want the content under "text" for both rows inserted into a variable.

Could someone tell me what to use here? I thought it would be mysql_fetch_field but that didn't work.

Thanks,
Mike

[devinemke]

$result = mysql_query('SELECT text FROM table');
while ($row = mysql_fetch_assoc($result)) {$array[] = $row['text'];}
print_r($array);

[webmasternovis]

Didn't realise it was that simple, thanks.