php - 使用 $query = mysql_query 选择更多表

Question

我可以使用它选择更多表格吗？

$table = "users";
$query = mysql_query("SELECT title, smalltitle, FROM $table ORDER BY date DESC");
while($result= mysql_fetch_array($query))
{  
echo'<div id="title"> ';
    echo'<p>'.$result['title'].'</p>';
echo'</div>';

echo'<div id="name"> ';
    echo'<p>'.$result['name'].'</p>';
echo'</div>';
}

我想要表“users”中的标题/小标题和表“gmsg”中的名称/文本

Answer 1

使用此查询 -

"SELECT users.title, users.smalltitle, gmsg.name FROM users, gmsg $where_condition ORDER BY users.date DESC"

$where_condition 将是匹配 users 和 gmsg 的条件，例如 -

$where_condition = "users.id = gmsg.user_id"; //Or whatever it is