mysql_fetch.....

[jayrod_84]

I'm trying to fetch one value from a field and put it into a variable.. I'm confused as to what would be the best way to do this. My query is this.

select max(var_id) from table

var_id = is an integer.

doing this...

while ($line = mysql_fetch_field($result2, MYSQL_ASSOC)){
 var_dump ($line);
}

results in a null value.

any advice?