如何加入2选？[重复]

Question

我应该输入另一个查询从另一个表中获取数据，怎么做？

第一个查询

$actor_id = $_GET["id"];
$nome= $row ['nome'];
$sql = "select * from gallery WHERE actor_id_fk=". $actor_id;
$rs = mysqli_query($conn, $sql); 

要包含在代码中

$sql = "select * from actor WHERE actor_id=". $actor_id;

Answer 1

这是一个简单的连接:

select *              -- better enumerate the columns here that use "*"
from actor a
inner join gallery g on g.actor_id_fk = a.actor_id
where a.actor_id = ?  -- and better use prepared statements!