Slight problem here
I am using the function mysql_field_name to get the names of the fields in a table. that is fine.
What i want to do is get the values of the fields for each of the fields.
here is what i have so far
function display($table,$id,$sql)
{
$result = mysql_query($sql);
$field_list = mysql_list_fields("jobs","$table");
$num_fields = mysql_num_fields($result);
$row = mysql_fetch_array($result);
for($i = 0; $i < $num_fields; $i++)
{
$field_name = ucfirst(mysql_field_name ($result, $i));
$field_value = $row($field_list, $i);
print "$field_name<br>\n";
}
As you can see i can get the field name quite easily but now i need the values associated with the fields.
the strange thing is i have already done it before, but stupidly didn't keep a backup !!!!
Cheers
GM
