note 54565 added to function.mysqli-fetch-field

The "type" property will return a numerical representation of a field type instead of a "meaningful" string. Here is an array that may help you: <?php $mysqli_type = array(); $mysqli_type[0] = "decimal"; $mysqli_type[1] = "tinyint"; $mysqli_type[2] = "smallint"; $mysqli_type[3] = "int"; $mysqli_type[4] = "float"; $mysqli_type[5] = "double"; $mysqli_type[7] = "timestamp"; $mysqli_type[8] = "bigint"; $mysqli_type[9] = "mediumint"; $mysqli_type[10] = "date"; $mysqli_type[11] = "time"; $mysqli_type[12] = "datetime"; $mysqli_type[13] = "year"; $mysqli_type[252] = "blob"; // text, blob, tinyblob,mediumblob, etc... $mysqli_type[253] = "string"; // varchar and char $mysqli_type[254] = "enum"; ?> ---- Manual Page -- http://www.php.net/manual/en/function.mysqli-fetch-field.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+54565 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+54565&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+54565&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+54565&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+54565&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+54565&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+54565&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+54565&report=yes Search -- http://master.php.net/manage/user-notes.php