Obtaining the 'Max_data_length' value in MySQL 4

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?

SHOW TABLE STATUS FROM databasename

see the manual for more details.

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.