mysql db fields help

Anon

hi..im writing a php script that will allow me to view the field info of a given mysql table on the web instead of doing it through command line using "describe tableName"...

I'm using the php function "mysql_fetch_field" which returns some properites of the fields but not all...are there any other functions that could return say the default value of the field or a function that is more specific in returning the type of the field?

any help would be appreciated..thanks =)

Anon

use the Mysql library from PHPlib's getmeta() function returns everything you could possibly want about the fields of a specified able.

Anon

there isn't a php function getmeta() that would return all the info for the fields in a table..and if there is such a function it must be of a different name...does anyone know what it is? thanks...

Anon

If you reread my post you will see that the function is a function of the PHPLIB's mysql class. And yes it does exist

Go to

http://phplib.netuse.de

for more info

Anon

thanks..sorry i misread your reply and didnt realize u were referring to PHPLIB...thanks for your help =)