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


PHP Source Code » MySQL Database » Table MetaData »

 

Get column name, type and max length



<?php
   mysql_connect("mysql153.secureserver.net","navioo","password");
   mysql_select_db("navioo");

   $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>";
   }
?>


           
       



HTML code for linking to this page:

Follow Navioo On Twitter

PHP Source Code

 Navioo MySQL Database
» Table MetaData