= CURRENT_DATE order by LocDesc, EvtDate asc"; $result = mysql_query($query) or die(mysql_error()); $result2 = mysql_query($query) or die(mysql_error()); $result3 = mysql_query($query) or die(mysql_error()); echo "\n\t\n\t"; while ($row = mysql_fetch_array ($result)) { if ($row[LocId] == 2) { $date = ($row[EvtDate]); $a = explode("-",$date); $m=intval($a[1]); $d=intval($a[2]); $date=date('m/d/y',mktime(0,0,0,$m,$d,$a[0])); $cday = date('l',mktime(0,0,0,$m,$d,$a[0])); if($n % 2) {echo ""; // I'm in an even row }else{echo ""; // I'm in an odd row } echo "\n"; $n++; }} echo "\n\t\n\t"; while ($row = mysql_fetch_array ($result2)) { if ($row[LocId] == 9) { $date = ($row[EvtDate]); $a = explode("-",$date); $m=intval($a[1]); $d=intval($a[2]); $date=date('m/d/y',mktime(0,0,0,$m,$d,$a[0])); $cday = date('l',mktime(0,0,0,$m,$d,$a[0])); if($n % 2) {echo ""; // I'm in an even row }else{echo ""; // I'm in an odd row } echo "\n"; $n++; }} echo "\n\t\n\t"; while ($row = mysql_fetch_array ($result3)) { if ($row[LocId] == 5) { $date = ($row[EvtDate]); $a = explode("-",$date); $m=intval($a[1]); $d=intval($a[2]); $date=date('m/d/y',mktime(0,0,0,$m,$d,$a[0])); $cday = date('l',mktime(0,0,0,$m,$d,$a[0])); if($n % 2) {echo ""; // I'm in an even row }else{echo ""; // I'm in an odd row } echo "\n"; $n++; }} ?>

Harpoon Eddies
".$date."	".$row[Name]; echo "	".$row[EvtTime]."
Sunset Grill
".$date."	".$row[Name]; echo "	".$row[EvtTime]."
Village Bandstand
".$date."	".$row[Name]; echo "	".$row[EvtTime]."