所以我需要2个表中的信息,但是我的加入mysqli只是行不通的,有人能告诉我问题是什么吗?://我是内在加入的新手,所以我可能会理解一些错误的x_x
if($stream = $mysqli->prepare("SELECT $title.message_id, $title.message, $title.likes, $title.dislikes, $title.poster, $title.date, $title.closed user.rank, user.posts, user.reputation FROM $title INNER JOIN User ON $title.poster = user.username ORDER BY message_id ASC")){
$stream->execute();
$stream->bind_result($message_id, $message, $likes, $dislikes, $poster, $date, $closed, $rank, $posts, $rep, $usnm);
while($stream->fetch()){
您确定定义了$title
吗?您确定user
具有大写吗?
SELECT *
FROM $title
INNER JOIN user
ON $title.poster = user.username
ORDER BY message_id ASC;
看起来您缺少列之间的逗号:$title.closed<needs comma here> user.rank
首先,您在这里缺少昏迷:
$title.closed user.rank
,在查询内部,应将表"用户"用作"用户",并在内部联接中声明的大写字母。内部联接是错误的。
您应该始终通过连接表开始内部连接条件:
错误
FROM $title INNER JOIN User ON $title.poster = user.username
好
FROM $title INNER JOIN User ON User.username = $title.poster