Is FACT taking data?
Who is on shift?
(from FACT shift plan
and FACT logbook)
8)
$today=date("Ymd", mktime(0,0,0,date("m"), date("d"), date("Y")));
else
$today=date("Ymd",strtotime(date("Y-m-d", mktime(0,0,0,date("m"), date("d"), date("Y")))." -1 day"));
echo "
Night: ".$today." (date of sunset)
";
$query="SELECT u FROM calendar.Data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$today."' AND x=0 ";
//echo $query;
include ("db.php");
$db_id = mysql_connect($host, $user, $pw);
$result = mysql_query($query);
echo " Contact Info Shiftcrew:
\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
\n
\n ";
mysql_free_result($result);
echo "General Contact Info:
\n \n";
$query3="SELECT usertitle, fid8 FROM logbook.userfields LEFT JOIN logbook.users ON (uid=ufid) WHERE username='dorner'";
$result3 = mysql_query($query3);
while ($row3 = mysql_fetch_row($result3))
{
echo "- ".$row3[0].": ".$row3[1]."
\n";
}
mysql_free_result($result3);
echo "
\n";
?>