Well, that depends. Maybe you'd like a structure like this:
$rows[0]['fname']='Stan';
$rows[0]['lname']='Marsh';
$rows[0]['address']='South Park;
$rows[1]['fname']='Eric';
$rows[1]['lname']='Cartman';
and so on, or maybe just that one column, in an array like so:
$col[0]='value1';
$col[1]='value2;
and so on?
To do the second is pretty easy:
$res = query("select column from table");
$count = num_rows($res);
for ($i=0;$i<$count;$i++){
$col[$i]=result($res,$i,'colname');
}
Something very similar can be used to put all the columns in named versions like up top:
$res = query("select column from table");
$count = num_rows($res);
$fields = num_fields($res);
for ($i=0;$i<$count;$i++){
for ($j=0;$j<$fields;$j++){
$fname = field_name($res,$j);
$col[$i][$fname]=result($res,$i,$fname);
}
}
Hope that helps (untested code, if it doesn't work feel free to ask for help, but it should be pretty close to right...)
