I am trying to select the column names from a table to be displayed in a web page. Is there anyway to select column names without desc?
What's wrong with using DESCRIBE?
You could issue SELECT * FROM tbl_name WHERE 0 and then examine the result set metadata. Most APIs provide a way to get the column names from the metadata.
Thanks, Jake Johnson [EMAIL PROTECTED]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]