Tour Dates:

  NOW()) AND NOT (Status='Don''t Show') ORDER BY ShowTime"; // 1/1/2007 version $sqlstmt="SELECT Who, City, State, date_format(ShowTime,'%c-%e-%Y') AS sDate, date_format(ShowTime,'%l:%i %p') AS sTime, Venue, ContactName, ContactEmail, InfoURL, InfoPhone, TicketsPhone, Status FROM tour WHERE (ShowTime > '2007-01-01') AND NOT (Status='Don''t Show') ORDER BY ShowTime"; @$result=mysql_query($sqlstmt); // Display tour dates while ($row=mysql_fetch_assoc($result)) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } // End of code to output table ?>

WHO	CITY	ST.	DATE	VENUE	TIME	CONTACT	INFO	TELEPHONE
".$row["Who"]."	".$row["City"]."	"; if ($row["State"]=="") { print " "; } else { print $row["State"]; } print "	".$row["sDate"].""; if (($row["Status"]=="Tentative") OR ($row["Status"]=="Postponed")) { print" ".$row["Status"].""; } print "	".$row["Venue"]."	"; if ($row["sTime"]=="12:00 AM") { print "TBA"; } else { print $row["sTime"]; } print "	"; if ($row["ContactEmail"] != "") { print ""; if ($row["ContactName"]=="") { print "Email"; } else { print $row["ContactName"]; } print ""; } else { if ($row["ContactName"]=="") { print " "; } else { print $row["ContactName"]; } } print "	"; if ($row["InfoURL"]!="") { print "Website "; } if ($row["InfoPhone"]!="") { print "".$row["InfoPhone"].""; } if ($row["InfoURL"].$row["InfoPhone"]=="") { print " "; } print "	"; if ($row["TicketsPhone"]!="") { print $row["TicketsPhone"]; } else { print " "; } print "