Or, you can just ereg_replace("_", " ", "<column name>"); On Fri, 20 Aug 2004 12:20:44 +0800, Jason Wong <php-db@xxxxxxxxxxxx> wrote: > On Thursday 19 August 2004 18:28, balwantsingh wrote: > > > now my problem is that by default column name (of mysql table) is displayed > > as heading > > You are in control of the HTML that goes into the webpage. You don't have to > use the column names returned from the mysql query. So where's the problem? > > If you insist, you can use something like: > > SELECT clumsy_column_name AS goodname FROM ... > > Refer to MySQL documentation for more info. > > -- > 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 > ------------------------------------------ > /* > Left to themselves, things tend to go from bad to worse. > */ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- randy sesser@xxxxxxxxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php