php - 通过从具有公共(public)列的两个表中选择数据来未定义索引

Question

我有两个表 - home 和 posts；home.artid 等于posts.id。

想要从 home 中选择 id、artid、inde 以及从 posts 中选择 title
其中 home.pos 是 slider:

$items = "";
$st = $db->query("select home.id, home.artid, home.inde 
                    from home 
                        join posts on home.artid = posts.id 
                    where home.pos = 'slider' 
                    order by home.inde asc");
while ($row = $st->fetch()){
    $items .= "<div class='slidertitle'>" . $row['posts.title'] . "</div>\n";
}
echo $items;

错误:
未定义索引 posts.title...

有什么帮助吗？

Answer 1

如果您想选择posts.title，请选择它

$st = $db->query("select home.id, home.artid, home.inde, 
                        posts.title
                from home 
                    join posts on home.artid = posts.id 
                where home.pos = 'slider' 
                order by home.inde asc");

// and it would be called just `title` 

while ($row = $st->fetch()){
    $items .= "<div class='slidertitle'>" . $row['title'] . "</div>\n";
}
echo $items;