CODEWITHSUNDEEP
phpmysql
user7461846
user7461846

Reputation:

undefined index by selecting data from two tables with a common column

I have two tables - home and posts; home.artid is equal to posts.id.

Want select id, artid, inde from home PLUS title from posts
where home.pos is 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;

Error:
Undefined index posts.title...

Any help?

Upvotes: 0

Views: 29

Answers (1)

RiggsFolly
RiggsFolly

Reputation: 94672

If you want to select posts.title then select it

$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;

Upvotes: 1

Related Questions