php - 无法动态创建表名中带有空格的表

Question

我想使用另一个表行中的表名称创建新表，这就是我到目前为止所做的

<?php
header('content-type:application/json; charset=utf-8');
include "db.php";
$sql=mysql_query("SELECT * from tb1");
while($row=mysql_fetch_assoc($sql))
$out[] = $row['title'];//see below what it outs
for($i=0;$i<=count($out);$i++)
{
$query = 'CREATE TABLE  '.$out[$i].' (PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))';
$sqls = mysql_query($query);
}
// if (!$sqls) {
  //die('Invalid query: ' . mysql_error());
//}

?>

$out[] 的输出类似于

word one word two word three


Note:its not a single title it has three words
word one-->title one
word two -->title two
word three-->title three

Answer 1

不建议带空格的表名、列名，但如果确实需要创建带空格则需要用反引号括起来

$query = 'CREATE TABLE  `'.$out[$i].'`

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html