Variable varibles with array.

[genetheblue]

Hi I'm trying to use variable variables to access fields from a db. I have code that works, but I don't understand why I need to declare it as a variable outside of the array as well.

 

What I have:

$fname = 'fname'; // Why do I need this??

$fieldList = array('fname');

$output = $row->${fieldList[0]};

 

This works, however... if I leave out $fname='fname' it does not work. I read the docs, and tried $output = $row->${fieldList}[0] but that doesn't make sense when accessing a property of the row object.

 

Is this the way it is, or am I doing something wrong that I need to double up on my field declarations to get them as a passable array? This way, I will need to declare every field in the db I want, then put it in the array which just seems strange.

 

Thanks for any help...

[Barand]

<?php
$res = mysql_query ("SELECT fname FROM mytable");
while ($r = mysql_fetch_object($res))
{
    echo $r->fname . '<br/>';
}

[genetheblue]

Thanks for the response,

 

... but I'm trying to get this in a function so I can pass an array of fields, and loop through them - using the array elements as my field accessor(?)).

 

I don't want to hardcode fname into the loop. I will have another loop to build a table based on which fields are passed in the array I'm trying to use.

 

 

[BlueSkyIS]

what do you mean by "if I leave out $fname='fname' it does not work"? Do you see an error, a "Notice"? You shouldn't need to declare a variable unless you have Notices turned on...

 

Anyway, try using this instead:

 

$output = $row[${$fieldList[0]}];

 

 

 

[genetheblue]

The error message(sorry dumb to leave that out!) before was 'Cannot access empty property'.

 

If I use $output = $row[${$fieldList[0]}]; I get an error:

'Cannot use object of type stdClass as array'

 

 

However, if I simply use 1 variable in my loop...

$curField = fieldList[ii];

$row->${$curField}

 

It works without me having to declare variables all over the place - I can just declare my array and pass it like I wanted. I still don't fully understand why, so if anyone can educate me great. I'm also still trying to find a good debugger that hopefully isn't expensive! I feel lazy starting php and wishing I could watch my objects in real time It would be nice to be able to watch these objects - but just the nature of web development states(or lack of) is still newer to me.

 

But I do have a solution that isn't making me cringe everytime I want to call this function.

 

Thanks much....