php - 从两个表中选择变量

Question

我有两个表:

comments: id, username, autorpost, comment, id_post, time

posts:  id, autorid, autor, date, longitude, latitude, title, text, town, time

现在我只想选择表中的这些行，其中我保存在 cookie $username = $_COOKIE['username']; 中的用户名具有相同的值表评论中的用户名。这可能还是我应该添加任何列？

Answer 1

"SELECT
    c.id,
    c.username,
    c.autorpost,
    c.comment,
    c.id_post,
    c.time,
    p.id,
    p.autorid,
    p.autor,
    p.date,
    p.longitude,
    p.latitude,
    p.title,p.text,p.town,p.time 
from comments c 
JOIN posts p 
on p.id=c.id_post 
where c.username='".$username."'";