PHP + MySQL : When I select from two tables, 如何定义我要从哪个表中取 "id"

Question

我有两个表，每个表都有一个“id”字段。这是两个表:

news    : id, authorid, datetime, body
authors : id, name

我有这个选择查询:

SELECT * FROM news, authors WHERE (news.authorid = authors.id) ORDER BY news.datetime DESC;

然后，在 PHP 中，我想使用表 news 的 id。我有这段代码:

while ($row = mysql_fetch_array($result)) 
{
    // I want to take news.id, but it gives an error:
    echo $row["news.id"]; // error: "Undefined index: news.id"

    // And when I write only "id", it takes it of authors.
    echo $row["id"]; // this id is authors.id, but I want news.id
}

Answer 1

给他们起个别名

SELECT news.id AS news_id FROM news, authors WHERE (news.author = authors.id) ORDER BY news.datetime DESC;

或者

SELECT *, news.id AS news_id FROM news, authors WHERE (news.author = authors.id) ORDER BY news.datetime DESC;