table name creation with string replace ment

[webtechbharathi]

i want create a table name (E.g general science) but this table name store on my db as (general_scienc e) with under score.
after that i display this table in my web page its like (general science) with out underscore.how this possible please help me seniors.

[Atli]

Why are you displaying table names onto the website like that?

Generally speaking, if you are using structure identifiers (table/schema/database names) as variables, then there is a big problem in your database design. The database structure should be static: it should never have to change dynamically.

For example, say you were trying to set up a forum. You would not create a new table for each sub-forum on the site (like PHP, MySQL, C#, etc...), but rather create a single sub-forum table that lists the sub-forums.