Retrieving field information

[Chris_Evans]

Hi there,
I was browsing through the phpmyadmin files today trying to figure out how they retrieved the field information and then create the necessary boxes and give them each names for inputting information, but I couldn't understand it.

So I was wondering if someone could explain how to retrieve whether the field is a varchar or text field, a set or int field etc etc?

I thought that if I could retrieve that information along with the fields name then I could cut half the work that I'm currently having to do.

Thanks in advance,

Chris Evans

[dnszero]

i don't know if this will work for you or not but you can do...

SHOW CREATE TABLE tablename;

...to see the command used create the table (and hence the exact field types).

[Chris_Evans]

Hi, thanks for that. 🙂 All that needs to be done now is to work out how to retrieve the particular information from that query. However, it appears that there is a simpler way in phpmyadmin but I'm still struggling to figure out where abouts.

Chris