[RESOLVED] how do I get dynamically named mysql objects?

Tecktron

Hi,

I'm trying to dynamically get a row object, but the name of which I find from a list. It's easier to show than to explain:

$list=array("this","that","theother","another");
while($row = @ mysql_fetch_object($result)) {
    for($x=0;$x<count($list);$x++){
           echo $row->$list[$x]; 
//here's my issue want it to be (if $x is 2) $row->theother and echo the value for that
    }
}

I've Tried:
${$row->${$list}[$x]};
$row->${$list}[$x];
eval ("\$row->$list[$x];");

I'm not sure if this is this even possible. I'm not even sure if I'm about this the right way. Am I to be using variable variables or the eval function?

Thanks for ya help!

leatherback

Hi Tektron,

I seriouslyt doubt that you need any fanmcy variablevariables or something. It is not completely clear to me what output you are after, or what you try to achieve. Do you want to put every field in a row in an array? Or..?

Just general displaying array values:

echo $row[$x];

or:

foreach($list as $key=>$val)
{
echo $key;
echo $val;
}

Tecktron

I'm trying to get the value of an object whos name I'm trying to create from a list.

Some examples based on my code. The value of $x from the for loop; the value from the $list based on the array's position (AKA $x) and the code that needs be being executed (echoing a value from a fetched mySQL object (syntax: value=row->column).

$x | $list[$x]       | Code that should be executed
------------------------------------------------------
0  |  "this"        |  echo $row->this;
1  |  "that"        |  echo $row->that;
2  |  "theother" |  echo $row->theother;
3  |  "another"  |  echo $row->another;

Does that make more sense?

Tecktron

figured it, needed to set a temp variable, instead of using the array:

$temp=$list[$w];
echo $row->$$temp;

Thanks!