SQLSTATE[42S02] 找不到基表或视图时出错 1146.

Question

<?php
$assignmentsTable = $ssubjectnamewithoutspace.'_assignments';
try {
$stmt = $db->query('SELECT contentID, contentTitle,contentAuthor, contentLink FROM .$assignmentsTable ORDER BY contentID ASC');
while($row = $stmt->fetch()){
echo '<tr><td><a href="'.$row['contentLink'].'">'.$row['contentTitle'].'</a></td></tr>';            

}
} catch(PDOException $e) {
echo $e->getMessage();
}
?>

我收到此错误

SQLSTATE[42S02]：找不到基表或视图 1146 表 "epiz_5453564654654_newdata.$assignmentsTable"不存在

但是表中存在表，当我用表名替换$assignmentsTable时它可以工作......

Answer 1

查询中不会计算$assignmentsTable。

尝试：

$stmt = $db->query('SELECT contentID, contentTitle,contentAuthor, contentLink FROM `'.$assignmentsTable.'` ORDER BY contentID ASC');