I'm trying to automatically loop through the fields in a table (which is OK) and then loop through and print out the associated values for those fields.
this is what i have got so far
<?
require "jobs_include2.php";
$field_list = mysql_list_fields("jobs","agencies");
$num_fields = mysql_num_fields($field_list);
for($i=0; $i<$num_fields; $i++)
{
$field_name = mysql_field_name($field_list,$i);
$result = mysql_fetch_array($field_list,$i);
print "$field_name<br>\n";
print "$result<br>\n";
}
?>
All thats happening is the field names are being printed out but no values !
any ideas?
thanks
GM