<?php

mysql_connect('localhost:3306', $user, $password)

or die("Could not connect: " . mysql_error());

mysql_select_db("database");

$result = mysql_query("select * from table")

or die("Query failed: " . mysql_error());

/* получаем данные о колонке */

$i = 0;

while ($i < mysql_num_fields($result)){

echo "Information for column $i:<br>\n";

$meta = mysql_fetch_field($result, $i);

if (!$meta){

echo "No information available<br>\n";

}

echo "<pre>

blob: $meta->blob

max_length: $meta->max_length

multiple_key: $meta->multiple_key

name: $meta->name

not_null: $meta->not_null

numeric: $meta->numeric

primary_key: $meta->primary_key

table: $meta->table

type: $meta->type

unique_key: $meta->unique_key

unsigned: $meta->unsigned

zerofill: $meta->zerofill

</pre>";

$i++;

}

mysql_free_result($result);

?>