News and Events
Here is a list of my up and coming news and events.
$q1 = @mysql_query("SELECT * FROM $tdata WHERE did = '10' and sid = '1' AND bfield = 'live' ORDER BY adate ASC"); if (@mysql_num_rows($q1)) { $sswitch = true; for ($i = 0; $i < mysql_num_rows($q1); $i++) { if ($sswitch == true) { $sswitch = false; $style = "style='background: transparent;'"; } else { $sswitch = true; $style = "style='background: transparent;'"; } $row = mysql_fetch_object($q1); // shorten text $text = substr($row->atext,0,1000); // date $sdate = strtotime($row->adate); $tdate = date('l jS F, Y', $sdate); $row->atext = ereg_replace("\r\n","", $row->atext); print "
- $row->afield
- $tdate
- $row->atext
"; print "
Im sorry there appear to be no events.
"; } ?>