PHP：带有字段名称的MySQL查询

Question

Little question: With the following code...

<?php
$statement = "SELECT * FROM TABLE";
$query_unfetched = mysql_query($statement);
$query_num = mysql_num_rows($query_unfetched);
if ($query_num !== 1) {
    exit;
}
$query_fetched = mysql_fetch_object($query_unfetched);

$fielname = "ID";
echo $query_fetched->$fiedname;
?>

With this code, there is no output, because PHP somehow does not check that in $fieldname is an existing name of a field in the selected Table.

Why doesn't it work, have I made a mistake? Or are there any other ways to select a field whose name is saved in a var?

Thanks for the help!

Answer 1

Instead of using mysql_fetch_object, you could use mysql_fetch_assoc. It will return the result as an array, after which you can simply use your variable as a key.