3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php $_POST['CandidateID'] =987797631; $query = " SELECT w.WorkEligibilityInfoID,w.ApplicantID,e.ReverifyExpDate,e.ReverifyExpDate FROM CandidateApplicant As ca"; $query .= " JOIN WorkEligibilityInfo w"; $query .= " JOIN EmploymentEligibilityI9 e"; $query .= " ON ca.ApplicantID = w.ApplicantID"; $query .= " WHERE ca.CandidateID = " . $_POST['CandidateID']; $query .= " AND w.EmploymentEligibilityI9ID = e.EmploymentEligibilityI9ID"; $query .= " AND e.ReverifyExpDate is NOT NULL"; $query .= " AND e.ReverifyDocType > 0"; print_r($query);
based on 4lFr1
Output for 5.6.0 - 5.6.30, hhvm-3.18.5 - 3.22.0, 7.0.0 - 7.3.0rc3
SELECT w.WorkEligibilityInfoID,w.ApplicantID,e.ReverifyExpDate,e.ReverifyExpDate FROM CandidateApplicant As ca JOIN WorkEligibilityInfo w JOIN EmploymentEligibilityI9 e ON ca.ApplicantID = w.ApplicantID WHERE ca.CandidateID = 987797631 AND w.EmploymentEligibilityI9ID = e.EmploymentEligibilityI9ID AND e.ReverifyExpDate is NOT NULL AND e.ReverifyDocType > 0