MySQL data types using php

[shujunie]

Im currently building my own database admin programm and have hit a bit of stumbling block.
Its nothing major at the moment but made me think.

Does anyone have any ideas for outputting the mysql data types using php??

I am currently using:

$table = $_GET['table'];
$result = mysql_query("SELECT * FROM $table");
$fields = mysql_num_fields($result);
$rows = mysql_num_rows($result);
$table = mysql_field_table($result, 0);
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);
}

but all $type returns is int, real and blob.
How do i get it to say varchar or double for instance??

Anny assistance would be greatly appreciated

cheers

Shujunie

[logic_earth]

For php 4.3 and mysql 4.x the returned values are:

CHAR, VARCHAR, ENUM, SET: string
TINYINT, SMALLINT, MEDIUMINT, INT, INTEGER, BIGINT: int
FLOAT, DOUBLE, DECIMAL, NUMERIC: real
TIMESTAMP: timestamp
YEAR: year
DATE: date
TIME: time
DATETIME: datetime
TINYBLOB, MEDIUMBLOB, LONGBLOB, BLOB, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT: blob

you may get better data with: SHOW FIELDS FROM table.db
or http://dev.mysql.com/doc/refman/5.1/a/describe.html

Also to note " Like mysql_fetch_field, this returns the PHP type, not the MySQL type."

[r937]

try the INFORMATION_SCHEMA (mysql version 5)