That shows tables, not columns from a result set. :) ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -----Original Message----- > From: Jason Wong [mailto:php-db@gremlins.biz] > Sent: Friday, April 11, 2003 3:43 PM > To: php-db@lists.php.net > Subject: Re: Tables etc ..... > > On Saturday 12 April 2003 03:28, Chris Payne wrote: > > > Does anyone have any example code of how to get column names from a > mysql > > table without knowing how many columns there are? Basically what I need > to > > be able to do is to display the contents of a database without knowing > the > > column names as i'm trying to write something to manage my databases and > > i'd rather try it myself rather than use phpmyadmin all the time as you > > don't learn anything that way. > > mysql_list_tables() > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > ------------------------------------------ > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-db > ------------------------------------------ > /* > Familiarity breeds contempt -- and children. > -- Mark Twain > */ > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php