Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: PHP
Posted by: Jim Holden
Added: May 10, 2018 5:30 AM
Modified: May 13, 2018 7:29 AM
Views: 20
Tags: no tags
  1. mysqli_select_db($connSecureFlying, $db_name);
  2. $query_rsAircraft = "SELECT DISTINCT
  3.  a.AC_Type,
  4.  a.Display,
  5.  z.AC_Type_Name,
  6.  z.AC_TypeID
  7. FROM
  8.  aircraft a LEFT JOIN
  9.  z_ac_type z ON a.AC_Type = z.AC_Type_ICAO
  10. WHERE
  11.  z.AC_TypeID IS NOT NULL AND
  12.  a.Display = -1
  13. ORDER BY
  14.  a.AC_Type,
  15.  a.AC_No";
  16. $rsAircraft = mysqli_query($connSecureFlying,$query_rsAircraft) or die (mysqli_error($connSecureFlying));
  17. $row_rsAircraft = mysqli_fetch_assoc($rsAircraft);
  18. $totalRows_rsAircraft = mysqli_num_rows($rsAircraft);