Table types

[OwenTheSamoan]

This is more of a sql question than php so I apologize. Does anyone know what command I would use to find out what type of table I am using as far as MyIsiam or INNODB? If I have a table named users how would I know if it is INNODB or MyIsam? Thanks.

Owen The Samoan

[Ernie_]

SHOW TABLE STATUS FROM your_database;
The column 'Engine' will reveal which engine is used on your tables in that database.

Btw: http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html

[OwenTheSamoan]

thank you very much for the help