%s%s"; $dbfmtrow2="From %s to %s
%sRegister"; $dbfmtrow2b="%s
%sRegister"; $dbfmtrow3="%s"; $dbfmtrow4="More Details"; $separator="

---

"; // output classes $db=classesdb_open(); $thisday = date("Y-m-d"); //$criteria=""; $criteria="expiredisplay >= '$thisday'"; $sorthow="id"; // just sort by id $sqlresult=classesdb_getselecteditems($db,$criteria,$sorthow); $outputbuf=""; $count=0; $mon=array("01"=>"Jan","02"=>"Feb","03"=>"Mar","04"=>"Apr","05"=>"May","06"=>"Jun","07"=>"Jul","08"=>"Aug","09"=>"Sep","10"=>"Oct","11"=>"Nov","12"=>"Dec"); while($rs=classesdb_gettablerow($sqlresult)) { $outputbuf.=sprintf($dbfmtrow,$rs['title'],$rs['fee']); $tmary=explode("-",$rs['start']); $starttm=sprintf("%s %s %s",$mon[$tmary[1]],$tmary[2],$tmary[0]); $tmary=explode("-",$rs['end']); $endtm=sprintf("%s %s %s",$mon[$tmary[1]],$tmary[2],$tmary[0]); if ($rs['start']==$rs['end']) { $outputbuf.=sprintf($dbfmtrow2b,$starttm,$rs['datetime']); } else { $outputbuf.=sprintf($dbfmtrow2,$starttm,$endtm,$rs['datetime']); } if ($rs['description']) { $outputbuf.=sprintf($dbfmtrow3,$rs['description']); } if ($rs['URL']) { $outputbuf.=sprintf($dbfmtrow4,$rs['URL']); } $outputbuf.=$separator; $count++; } // while if ($count) { } else { $outputbuf="no classes presently."; } classesdb_close($db); ?>

home    courses    directions    career events    facilities rental    registration    5998 Alcalá Park, San Diego, CA 92110-2492 [ contact us ] design by open range enterprises