   #PHP Manual MySQL Functions mysql_field_table mysql_free_result

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                               mysql_field_type

   (PHP 3, PHP 4 )
   mysql_field_type --  Get the type of the specified field in a result

Description

   string mysql_field_type ( resource result, int field_offset)

   mysql_field_type() is similar to the mysql_field_name() function. The
   arguments are identical, but the field type is returned instead. The
   field type will be one of "int", "real", "string", "blob", and others
   as detailed in the MySQL documentation.

   Example 1. mysql_field_type() example
   <?php
       mysql_connect("localhost", "mysql_username", "mysql_password");
       mysql_select_db("mysql");
       $result = mysql_query("SELECT * FROM func");
       $fields = mysql_num_fields($result);
       $rows   = mysql_num_rows($result);
       $table = mysql_field_table($result, 0);
       echo "Your '" . $table . "' table has " . $fields . " fields and "
   . $rows . " record(s)\n";
       echo "The table has the following fields:\n";
       for ($i=0; $i < $fields; $i++) {
           $type  = mysql_field_type($result, $i);
           $name  = mysql_field_name($result, $i);
           $len   = mysql_field_len($result, $i);
           $flags = mysql_field_flags($result, $i);
           echo $type . " " . $name . " " . $len . " " . $flags . "\n";
       }
       mysql_free_result($result);
       mysql_close();
   ?>

   The above example would produce the following output:
Your 'func' table has 4 fields and 1 record(s)
The table has the following fields:
string name 64 not_null primary_key binary
int ret 1 not_null
string dl 128 not_null
string type 9 not_null enum

   For downward compatibility mysql_fieldtype() can also be used. This is
   deprecated, however.
   ______________________________________________________________________

   Prev              Home              Next
   mysql_field_table  Up  mysql_free_result
