Arrays

[Anon]

Easy question, but not for me.

I've made a query of a single column that creates several elements in an array. I am using mysql_fetch_array with $data_query[?] the relevant number to get the nth element out, this does not seem to work with the array from a single column, but it does work with rows?

I want to assign the elements to a predefined variable.

Thanks

[Anon]

try this right after the query, assuming the query records are returned in the resourceID $results

if ($results){
while($row = mysql_fetch_array($results)){
$rows[] = $row;
}
}

Then to access the data in $rows,

if (is_array($rows)){
echo $rows[$x]['coulumn_name'];
}

where $x is the row you want to pull the record from, and coulumnname is the name of the coulumn

or

if (is_array($rows)){
echo $rows[$x][$y];
}

where $x is the row you want to pull the record from, and $y is the index of the column you want