selecting field information in SQL

i hope this doesn't sound totally confusing: how do i get certain fields' information from a table, even if no records exist? i need to get information about the fields (size and if numeric) of a table that i usually get with my select stmt, but my select statement will sometimes return an empty record set and so i don't get the field information.

i'm using mysql.

thanks for any help,
kelli Received on Fri Apr 27 2001 - 19:07:18 CEST