'2008-01-01' ORDER BY gt.date ASC");*/ $results = mysql_query("SELECT gt.onetype, gt.twotype, gt.threetype, gt.oneunit, gt.twounit, gt.threeunit, gt.name, gt.nametag, gt.statetag, gt.swim, gt.bike, gt.run, gt.city, gt.state, gt.uid, UNIX_TIMESTAMP(gt.date) as foo FROM gforum_Triathlons AS gt RIGHT JOIN gforum_TriathlonsStates AS gts ON gts.regionid = '".intval(mysql_escape_string($_GET[region]))."' AND gt.statetag = gts.statetag WHERE valid = 1 AND date > '".$min_date."' ORDER BY gt.date ASC"); $none = FALSE; if (mysql_num_rows($results) == 0) { $none = TRUE; } /*$results = mysql_query("SELECT onetype, twotype, threetype, oneunit, twounit, threeunit, name, nametag, statetag, swim, bike, run, city, state, uid, UNIX_TIMESTAMP(date) as foo FROM gforum_Triathlons RIGHT JOIN WHERE regionid='$_GET[region]' AND valid=1 AND date > '2008-01-01' ORDER BY date ASC");**/ // set the page title $pagetitle = $regionname; $selected_item = mysql_escape_string($_GET[region]); // set meta tags $meta_keywords = "triathlons in ".$regionname; $meta_description = "Trying to find triathlons or duathlons in ".$regionname."? Here is a listing of all ".$regionname." triathlons. Users can even rate and comment on races."; ?>

Triathlons

Back " class="btn btn-white float-right">Add Race

Region

No triathlons have been entered yet for $regionname.

"; } ?>