mysql_field_type

Senario:

$sql = "SELECT Name FROM tblUser";
$result = mysql_query($sql);
$type = mysql_field_type($result, ? );

can anyone tell me what should I put for this '?' if I only want to select this field and know about the field type of this field?

Thanks for helping.

here you will get a detailed information about the fields

$result = mysql_db_query($your_database,"SHOW FIELDS FROM " . $your_table);

then fetch array the result

$row = mysql_fetch_array($result);

echo $row["Field"];
echo $row["Type"];
echo $row["Default"];
echo $row["Null"];
echo $row["Extra"];
echo $row["Attributes"];

presumably "int field_offset" means ordinal position of the field you want to interrogate.