Obtaining the 'Max_data_length' value in MySQL 4

Databases
1

I want to be able to select the ‘Max_data_length’ value for a table. I see that in MySQL 5 you can get this from the information_schema tables, but this is a MySQL 4.1.22 database and so those aren’t available.

Anyone know how to do this?

2 
SHOW TABLE STATUS FROM databasename

see the manual for more details.

3

guelphdad, thanks for that but I was looking to be able to use SELECT so that I could run the query in PHP and use the value to make some calculations.