[RESOLVED] Can't use LIMIT with SHOW COLUMNS?

[mellow]

I am trying to set up an admin for db tables. I do not want users to be able to edit the id (auto-increment) column. I was trying to be more efficient by using mysql to sort results rather than doing it with php after the result set was queried.

I cannot get the query to work though when i do it this way:
$sql = "SHOW COLUMNS FROM $table LIMIT 1,10"; //bypassing id column here

If I leave the LIMIT off it works. I have searched the mysql manual, php manual, this forum, and the mysql forum but couldn't find anything! Assuming using limit is not possible with this query? Just wanting verification.

[Weedpacket]

Judging from what the manual says I'd say LIMIT isn't an option.

Instead, you could use the standard INFORMATION SCHEMA tables.

[mellow]

Thanks a lot. I guess omission means you can't use it. I will check out the schema tables.