Roe Name With A SPace

[phpretard]

I knoe I Made A Slight Mistake When I Named A Batabase Table With A Space In The Name.  Isn't there a work around for that.  It's kind of too late for me o go and change the whole thing around.

 

 

$row="No Good";

$result = mysql_query("SELECT * FROM $row ");

 

Thank you for your help.

[Fadion]

Rename the table and run a batch replace of "No Good" with "No_Good" in all your script files. Whats so much of a problem with that?

[phpretard]

I really didn' want it to display an underscore.

[phpretard]

Or maybe I don't know what a batch replace is.

[947740]

What is the problem with displaying an underscore?  Are you displaying the tablename on the page?

[phpretard]

Yes It Goes on the page and doesn't look right.

[947740]

You could do a string replace.

[radar]

A little tip for databases: database, table names, and column names should NOT have a space in them..  so in that case the column name should be No_Good...  if its a row you are looking to find that has a space in it, you would then say insert a row where No_Good = No Good or whatever...

 

then your query would theoretically work. as it would get everything inside the table No_Good the information from there would then be shown with no spaces...

 

make sense at all?

[BlueSkyIS]

use back-ticks.

 

$result = mysql_query("SELECT * FROM `$row` ");