How to grab mysql field dynamically via php

Question

In php I access results from a mysql query results set as such:

$results->fldname;

My question is how can I dynamically pass the field name to $results? For example:

$results->fld_$name;

Answer 1

try this:

$results->{'fld_'.$name};
//or (not recommended)
$name = 'fld_'.$name;
$results->$name;

Answer 2

If you're asking if that's possible in PHP, then yes:

$field = "fld_name";
$result->$field;

This would be the same as:

$result->fld_name;