Guest User

Untitled

a guest
Mar 19th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. SELECT * FROM (SELECT `id_reysa` FROM `Reys` WHERE `otkuda`=
  2. (SELECT `id_aeroporta` FROM `Aeroporti` WHERE `gorod` = "Москва") and `kuda`=
  3. (SELECT `id_aeroporta` FROM `Aeroporti` WHERE `gorod` = "Лос-Анджелес")) as reyses
  4.  
  5. $sql = "SELECT * FROM (SELECT `id_reysa` FROM `Reys` WHERE `otkuda`=(SELECT `id_aeroporta` FROM `Aeroporti` WHERE `gorod` = "".$search_from."")
  6. and `kuda`=(SELECT `id_aeroporta` FROM `Aeroporti` WHERE `gorod` = "".$search_to."")) as reyses";
  7.  
  8. /*$sql = "SELECT * FROM `Reys`"; -этот запрос работает, выводит 2 строки*/
  9.  
  10. if(!$result = $mysqli->query($sql))
  11. {
  12. echo "Запрос: " . $sql . "n";
  13. echo "Номер_ошибки: " . $mysqli->errno . "n";
  14. echo "Ошибка: " . $mysqli->error . "n";
  15. exit;
  16. }
  17.  
  18. if($result->num_rows===0)
  19. {
  20. echo $result->num_rows; //Выводит 0
  21. exit;
  22. }
  23.  
  24. while ($row = $result->fetch_assoc())
  25. {
  26. print_r($row);
  27. echo "<br />";
  28. }
Add Comment
Please, Sign In to add comment