Re: [PHP-DB]different heading

[randy]

Or, you can just  ereg_replace("_", " ", "");

On Fri, 20 Aug 2004 12:20:44 +0800, Jason Wong <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB]different heading

[Jason Wong]

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

[PHP-DB]different heading

[balwantsingh]

pls. help me.
i have made one webpage where user for getting a report checks the checkbox as per his 
requirement and accordinly only that data is retrieved from mysql.  i used array and 
loop for getting the data. 

now my problem is that by default column name (of mysql table) is displayed as heading 

let me explain
suppose the column name of mysql table is ==> Enter_Date, Opening_Units etc. etc. than 
date is displayed under Enter_Date and Opening_Units

i want to use different heading than column_name (even if underscore sign (_) between 
Opening_Units is removed i will be happy)  but keep in my mind that i have many 
columns.

thanks for your help.


balwant

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php