space in table name MySQL

seabird

Hi everyone,

I really want to create a table name with a space in it.

e.a. About Me

I use the table names to create links on my page and want the space for that purpose, but I can't seem to get MySQL get it to accept queries. The table exists but I can't use it.

Is it possible? And if so, how? I tried everything I can come up with and couldn't find this issue in the manual.

I tried using:
'About Me'
"About Me"
(About Me)
etc.

Didn't work,
Please Help!!!
Jacco

csn

Just use underscores and str_replace().

seabird

I know I can use a underscore in the name, but how do I get rid of that one in the output???

Pretty new to this, but let me give you some code I wrote for this:

<?PHP
$link = mysql_connect();
$db=content;

if (! $link)
die( "couldn't connect");
mysql_select_db($db)
or die ("won't open test:".mysql_error() );

$db_res=mysql_list_tables("$db",$link);
$num=mysql_num_rows($db_res);
for($x=0; $x<$num; $x++)
{
$table=mysql_tablename($db_res,$x);
/////////Don't want underscore here////////////////
print "<option>".$table."</option><br>
////////That way my link shows the space/////////
{
$query = "SELECT DISTINCT * FROM $table";
$result = mysql_query($query) or die("Error in query");

      while($row = mysql_fetch_assoc($result))
{
print "<option value=".$row['Field2'].">&nbsp;&nbsp;-".$row['Field1']."</option><br>\n";
}
      }

}
?>

sorry for being a newbie
Jacco

sasmon

And what is wrong with csn's solution?-->

$table2=str_replace("_", " ", $table);
print "<option>".$table2."</option><br>

I guess this should do the trick (not tested!)

regards,

Sascha

seabird

It worked, but I had to recode the _ after the print function or my query would stop.

small error on my behalf.

Thanx,
Jacco

sasmon

good for you,

that is why I created an extra var, so your query shouldn't be bothered. ;-)

regards,

Sascha