jeff5656 Posted January 20, 2010 Share Posted January 20, 2010 When I query these two tables, if a record has no value in pod, it doesn't even get selected: $consultsq1 = "SELECT icu.mrn, icu.id_incr, bundle.pt_id, icu.pod as pod1, bundle.pod as pod2, bundle.vent_id FROM icu INNER JOIN bundle ON icu.id_incr = bundle.pt_id "; $result = mysql_query ($consultsq1) or die ("Invalid query: " . mysql_error ()); while ($row = mysql_fetch_assoc ($result)) { So records where pod is blank in the BUNDLE table, doesn't even get selected when I echo out the while loop. Link to comment https://forums.phpfreaks.com/topic/189202-records-with-blank-values-are-not-selecting/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.