Is FACT taking data?
Who is on shift?
(from FACT shift plan
and FACT logbook)
Night: ".$date." (date of sunset)
";
$query="SELECT u FROM calendar.data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$date."' AND x=0 ";
//echo $query;
include ("db.php");
$db_id = mysql_connect($host, $user, $pw);
$result = mysql_query($query);
echo " Contact Info:
\n \n";
while ($row = mysql_fetch_row($result))
{
//echo " ".$row[0]." ";
$query2="SELECT usertitle, fid8 FROM logbook.userfields LEFT JOIN logbook.users ON (uid=ufid) WHERE username='".$row[0]."'";
//echo $query2;
$result2 = mysql_query($query2);
while ($row2 = mysql_fetch_row($result2))
{
echo "- ".$row2[0].": ".$row2[1]."
\n";
}
mysql_free_result($result2);
}
echo "
\n";
mysql_free_result($result);
?>