Active Prayer Vigil Sign-up Sheets
Community Name
Weekend Name
Weekend Dates
Slots
Tot/Open
if($result) { while($comm = mysql_fetch_array($result)) { if(!($result2 = mysql_query(" SELECT Count(*) FROM PVigilSlot WHERE PVigilID = $comm[3] AND (SlotName IS NULL OR SlotName = \"\") GROUP BY PVigilID"))) die("Error: [GetComm] " . mysql_error()); $comm2 = mysql_fetch_array($result2); ?>
if ($comm2[0] == "") { echo "
".$comm[2]."
"; echo "
Filled (Print)
"; } else { echo "
".$comm[2]."
"; echo "
".$comm[7]." / ".$comm2[0]."
"; } ?>
} } ?>