2009/11/24 keyser soze <bajopala...@yahoo.com.ar>: > mysqli_fetch_field provide result metadata > like 'column name', 'max length', 'datatype' etc > but i need the "comment" of each column > > is this possible?
The table that stores data about columns is information_schema.COLUMNS. You're looking for the COLUMN_COMMENT column. Eg SELECT COLUMN_COMMENT FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'database' AND TABLE_NAME = 'table' AND COLUMN_NAME = 'column'; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
