Get query results using array

[deiv82]

Hi everybody,

just would like to ask to someone more expert than me if it's possible to use a variable (or maybe better, array) as name of the column from which I should get the results with the query.

So I mean instead of this:

while ($results = mysql_fetch_array($query)) {
    $id = $results['id'];
    $name = $results['name'];
        ...
}

... something like this

$fields = array("id","name", ...);
$i = 0;
 
while ($results = mysql_fetch_array($query)) {
    $id = $results[$fields[$i]];
    $name = $results[$fields[$i]];
    ...
       $i++
}
 

Ok, this doesn't work... but is there maybe some other way...?

Thanks

[ck9663]

I think it's more of a question for your front-end tool and not sql server. You might be able to access the resultset using an object that uses a number based property to identify the sequence of columns in a resultset.

Good Luck!!!


~~ CK

[ariful alam]

if you are required to pike single column then you may use single dimensional array or for row columns, you may need to use a double dimensional array.

And by the way, this is a question of front-end that you used to pike query result.

[deiv82]

ok, sorry for the wrong section... anyway thanks from your answer they might be useful to me!