Get column name, type and max length : Table MetaData « MySQL Database « PHP

PHP 1.  Chart 2.  Class 3.  Components 4.  Cookie Session 5.  Data Structure 6.  Design Patterns 7.  Development 8.  Email 9.  File Directory 10.  Form 11.  Functions 12.  Graphics Image 13.  HTML 14.  Language Basics 15.  Login Authentication 16.  Math 17.  MySQL Database 18.  Network 19.  String 20.  Web Services SOAP WSDL 21.  XML Microsoft Office Word 2007 Tutorial Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Python SQL Server / T-SQL Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial

PHP » MySQL Database » Table MetaData   Get column name, type and max length <?php    mysql_connect("mysql153.secureserver.net","java2s","password");    mysql_select_db("java2s");    $query = "SELECT * FROM Employee LIMIT 1";    $result = mysql_query($query);    $fields = mysql_num_fields($result);    for($count=0;$count<$fields;$count++) {       $field = mysql_fetch_field($result,$count);       echo "<p>$field->name $field->type ($field->max_length)</p>";    } ?>                     Related examples in the same category 1.  Get table column flag 2.  Get column data type 3.  Get field length 4.  Total number of fields in a table

ww_w_.___j__a___v_a_2s_.___c___o___m__ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.