how would i get the details of a mySQL table, like the field names and type? all help is appreciated.
There are several mySQL function to do this
http://www.mysql.com/doc/S/H/SHOW_DATABASE_INFO.html
at the mysql promopt, type:
mysql> use DATABASE_NAME mysql> describe TABLE_IN_DATABASE
Just replace the caps with the appropiate fields. 🙂
