[RESOLVED] Fetching Field Values using a $var for field name

[bgallagher]

~totaly stumped ~

Is there a way to fetch the 'value' of a field when using a variable for the field name in a select query? ex:

$field='name_of_the_table_column';

$fv=mysql_query("SELECT $field FROM table where condition=$condition");
$fieldValue =$mysql_fetch_array($fv);

the tables field name is determined
the condition is met.
there is only one row where that condition exists.
there is only, one record set, one ""$field"" value, one table field named"" $field"".

now what do i do to retrieve the 'VALUE' from that specific field ?

~ totaly stumped 😕

[misterx]

Simply

echo $fieldValue[$field];

[bgallagher]

the code returned no error ... however it also return no value.
i've tried :
echo $fieldValue[$field];
echo $fieldValue['$field'];
print " $fieldValue[$field];
print " {$fieldValue[$field]}";
print" $fieldValue['$field']";

none return a value at all.

~ totaly stumped

[leatherback]

what does this doe for you:

$field='name_of_the_table_column';
$fv=mysql_query("SELECT $field FROM table where condition=$condition");
echo "Rows found:".mysql_num_rows($fv)."<br />";
$fieldValue =$mysql_fetch_assoc($fv);
print_r($fieldValue);
echo "With 0:".$fieldValue[0];
echo "<br />With variable:".$fieldValue[$field];

[bgallagher]

Alrighty..........well thank you guys very much for your replys both of you were right on target and so was I!....
250 lines of code above the chunk that i was working on i found the error.
and it went like this!
<input type='hidden' name='fieldn' value={$h1['setField']}'>

a missing ' that made every input value there after useless!
again...thank you for your contribution to my insane world!

~ no longer stumped!

[bradgrafelman]

Don't forget to mark this thread resolved.