PHP mysql_fetch_field() Function

|  | Search W3Schools : |

HOME | HTML | CSS | XML | JAVASCRIPT | ASP | PHP | SQL | MORE... |  | References | Examples | Forum | About

ADVERTISEMENTS XML Certification Download XML editor Custom Programming |  |

Table of contents

PHP Basic
PHP HOME
PHP Intro
PHP Install
PHP Syntax
PHP Variables
PHP String
PHP Operators
PHP If...Else
PHP Switch
PHP Arrays
PHP Looping
PHP Functions
PHP Forms
PHP $_GET
PHP $_POST
PHP Advanced
PHP Date
PHP Include
PHP File
PHP File Upload
PHP Cookies
PHP Sessions
PHP E-mail
PHP Secure E-mail
PHP Error
PHP Exception
PHP Filter
PHP Database
MySQL Introduction
MySQL Connect
MySQL Create
MySQL Insert
MySQL Select
MySQL Where
MySQL Order By
MySQL Update
MySQL Delete
PHP ODBC
PHP XML
XML Expat Parser
XML DOM
XML SimpleXML
PHP and AJAX
AJAX Introduction
XMLHttpRequest
AJAX Suggest
AJAX XML
AJAX Database
AJAX responseXML
AJAX Live Search
AJAX RSS Reader
AJAX Poll
PHP Reference
PHP Array
PHP Calendar
PHP Date
PHP Directory
PHP Error
PHP Filesystem
PHP Filter
PHP FTP
PHP HTTP
PHP Libxml
PHP Mail
PHP Math
PHP Misc
PHP MySQL
PHP SimpleXML
PHP String
PHP XML
PHP Zip
PHP Quiz
PHP Quiz
PHP Exam

Selected Reading

Web Statistics
Web Glossary
Web Hosting
Web Quality
W3Schools Tutorials
W3Schools Forum
Helping W3Schools

# PHP mysql_fetch_field() Function

Complete PHP MySQL Reference

## Definition and Usage

The mysql_fetch_field() function returns an object containing information of a field from a recordset.

This function gets field data from the mysql_query() function and returns an object on success, or FALSE on failure or when there are no more rows.

Possible return values:

- name - Field name
- table - The table the field belongs to
- def - Default value for the field
- max_length - Maximum field length
- not_null - 1 if the field cannot be NULL
- primary_key - 1 if the field is a primary key
- unique_key - 1 if the field is a unique key
- multiple_key - 1 if the field is a non-unique key
- numeric - 1 if the field is numeric
- blob - 1 if the field is a BLOB
- type - Field type
- unsigned - 1 if the field is unsigned
- zerofill - 1 if the field is zero-filled

## Syntax

    mysql_fetch_field(data,field_offset)

Parameter | Description
--- | ---
data | Required. Specifies which data pointer to use. The data pointer is the result from the mysql_query() function
field_offset | Optional. Specifies which field to start returning. 0 indicates the first field. If this parameter is not set, it will retrieve the next field

## Tips and Notes

Note: Each subsequent call to mysql_fetch_field() returns the next field in the recordset.

## Example

    <?php
    $con = mysql_connect("localhost", "peter", "abc123");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }

    $db_selected = mysql_select_db("test_db",$con);

    $sql = "SELECT * from Person";
    $result = mysql_query($sql,$con);

    while ($property = mysql_fetch_field($result))
      {
      echo "Field name: " . $property->name . "<br />";
      echo "Table name: " . $property->table . "<br />";
      echo "Default value: " . $property->def . "<br />";
      echo "Max length: " . $property->max_length . "<br />";
      echo "Not NULL: " . $property->not_null . "<br />";
      echo "Primary Key: " . $property->primary_key . "<br />";
      echo "Unique Key: " . $property->unique_key . "<br />";
      echo "Mutliple Key: " . $property->multiple_key . "<br />";
      echo "Numeric Field: " . $property->numeric . "<br />";
      echo "BLOB: " . $property->blob . "<br />";
      echo "Field Type: " . $property->type . "<br />";
      echo "Unsigned: " . $property->unsigned . "<br />";
      echo "Zero-filled: " . $property->zerofill . "<br /><br />";
      }

    mysql_close($con);
    ?>

The output of the code above could be:

    Field name: LastName
    Table name: Person
    Default value:
    Max length: 8
    Not NULL: 0
    Primary Key: 0
    Unique Key: 0
    Mutliple Key: 0
    Numeric Field: 0
    BLOB: 0
    Field Type: string
    Unsigned: 0
    Zero-filled: 0

    Field name: FirstName
    Table name: Person
    Default value:
    Max length: 7
    Not NULL: 0
    Primary Key: 0
    Unique Key: 0
    Mutliple Key: 0
    Numeric Field: 0
    BLOB: 0
    Field Type: string
    Unsigned: 0
    Zero-filled: 0

    Field name: Address
    Table name: Person
    Default value:
    Max length: 9
    Not NULL: 0
    Primary Key: 0
    Unique Key: 0
    Mutliple Key: 0
    Numeric Field: 0
    BLOB: 0
    Field Type: string
    Unsigned: 0
    Zero-filled: 0

    Field name: Age
    Table name: Person
    Default value:
    Max length: 2
    Not NULL: 0
    Primary Key: 0
    Unique Key: 0
    Mutliple Key: 0
    Numeric Field: 1
    BLOB: 0
    Field Type: int
    Unsigned: 0
    Zero-filled: 0

Complete PHP MySQL Reference

## Learn XML with <oXygen/> XML Editor - Free Trial!

oXygen helps you learn to define, edit, validate and transform XML documents. Supported technologies include XML Schema, DTD, Relax NG, XSLT, XPath, XQuery, CSS.

Understand in no time how XSLT and XQuery work by using the intuitive oXygen debugger!

Do you have any XML related questions? Get free answers from the oXygen XML forum and from the video demonstrations.

Download a FREE 30-day trial today!

WEB HOSTING
Domain Name Registration & More!
$15 Domain Name Registration Save $20 / year!
Buy UK Domain Names Register Domain Names
Cheap Domain Names Cheap Web Hosting
Best Web Hosting
PHP MySQL Hosting
Top 10 Web Hosting
UK Reseller Hosting
Web Hosting
FREE Web Hosting

WEB BUILDING
Website Templates Flash Templates Website Builder Internet Business Opportunity
Custom Programming
FREE Trial or Demo Web Content Manager Forms,Web Alerts,RSS
Download XML editor
FREE Flash Website
FREE Web Templates

EDUCATION
US Web Design Schools
HTML Certification
JavaScript Certification
XML Certification
PHP Certification
ASP Certification

HOME or Top of Page |  | Printer Friendly
W3Schools is for training only. We do not warrant the correctness of its content. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy. Copyright 1999-2009 by Refsnes Data. All Rights Reserved.