use "Show Column <table_name>" instead of query. You can get the list of column names of the particular table. Thanks & Regards Udayakumar Sarangapani Sr. PHP Developer CompIndia Infotech Pvt. Ltd. Chennai. "Science is nothing but logic..." ----- Original Message ---- From: Jean Carlo <jsalas@xxxxxxxxxxxxxxxxxx> To: php-objects@xxxxxxxxxxxxxxx Sent: Wednesday, 3 September, 2008 11:02:47 PM Subject: Get Names of tables in mysql How can I get the field names from a specified MySQL table? I don't need the data, I just want to get the tables field names. [Non-text portions of this message have been removed] Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/ [Non-text portions of this message have been removed]