从数据库返回数据

查询是为长途汽车选择出发地和目的地，并为所选数据产生任何组合

此查询位于文件中：getPullman.php

include '../Includes/config.php';
$nomeArrivo=$_POST['nomeA'];
$nomePartenza=$_POST['nomeP'];
$sql="SELECT codl,fermatap,fermataa,ora
      FROM partenza,arrivo,orari,
      WHERE idp=codp,
      AND codo=ido,
      AND fermatap='$nomePartenza',
      AND fermataa='$nomeArrivo'";

$result=$conn->query($sql);

echo "<table>";
while($row=$result->fetch_assoc()){
    echo "<tr>";
    echo "<td>".$row['codl']."</td>";
    echo "<td>". $row['fermatap']."</td>";
    echo "<td>".$row['fermataa']."</td>";
    echo "<td>".$row['ora']."</td>";
    echo "</tr>";
}
echo"</table>";
$conn->close();