Altar Server Schedule

=to_days(Now())) order by sched.Date, sched.MassID";/* execute the query */$mqry=mysql_query($mqrystrng);/* Grab each line of data */while ($mline=mysql_fetch_array($mqry,MYSQL_ASSOC)){if ($mline["MassID"]<29 AND $mline["MassID"]!=5) ($bc="#33CCCC");else($bc="#FFCC66");echo "
";$frmdate=date("F d, Y:",strtotime($mline["Date"]));echo "";echo "";/* echo $mline["Date"].":  ".$mline["Descr"]."

"; *//* The inner loop with the detail will be inserted here */$dtqrystrng="Select First, Last from altserv left join detail on altserv.ID=detail.AsID where detail.schedID=".$mline["ID"]." order by Last, First";$dqry=mysql_query($dtqrystrng);while ($dline=mysql_fetch_array($dqry,MYSQL_ASSOC)){/* Table goes here */echo"

";}echo "
".$frmdate."".$mline["Descr"]." 
  $dline[First] $dline[Last]

";}/* Finally, close the database before exiting */mysql_close($link); ?>