Jump to content

records with blank values are not selecting


jeff5656

Recommended Posts

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.