Move to fields instead of rows?

[mrbippy]

Here is what I have:

$non_result = Select_Query("SELECT

SUM(non_system_01) as non_jan,
SUM(non_system_02) as non_feb,
SUM(non_system_03) as non_mar,
SUM(non_system_04) as non_apr,
SUM(non_system_05) as non_may,
SUM(non_system_06) as non_jun,
SUM(non_system_07) as non_jul,
SUM(non_system_08) as non_aug,
SUM(non_system_09) as non_sep,
SUM(non_system_10) as non_oct,
SUM(non_system_11) as non_nov,
SUM(non_system_12) as non_dec,
location_id
FROM Location WHERE acct_id = '$acct_id'
GROUP BY acct_id
ORDER BY location_id", $link);

From the results of this query I would like to move from field to field not by rows returned. It only returns one row anyway.

I have tried the standard while loop but since there is only one row I get the error "Cant Jump to row".

I tried mysql_field_seek but still don't get the results I'm looking for.

Thanks

[Feyi]

not quite sure what you want it to do. Could you give an example?

[mrbippy]

I need to get the value returned from each of the "SUM" statements in the query. But since they are all in the same result row I am having difficulty grabbing them one at a time.

I was just thinking I could, although maybe not the most effecient way, do something like:

$data = array("$non_jan","$non_feb","$non_mar","");

Then loop through the new array.

[pete_bisby]

If you used mysql_fetch_array, you could use the field names of the query. Or, if you still wish to use the result as an array:

for ($i=0; $i < 12; $i++) {
     $row_returned[$i];
}

So you traverse the columns of the result - PHP interprets the results of a MySQL query as an array, always starting at zero with the first column.