'2008-01-01'")); $intcount = mysql_num_rows(mysql_query("SELECT date FROM gforum_Triathlons WHERE points >= 40 AND points < 100 AND valid = 1 AND date > '2008-01-01'")); $midcount = mysql_num_rows(mysql_query("SELECT date FROM gforum_Triathlons WHERE points >= 100 AND points < 180 AND valid = 1 AND date > '2008-01-01'")); $ultracount = mysql_num_rows(mysql_query("SELECT date FROM gforum_Triathlons WHERE points > 180 AND valid = 1 AND date > '2008-01-01'"));**/ /**$sqlstatelist = "SELECT gts.statetag AS statetag, gts.statelong AS statelong, COUNT(gt.uid) AS numshops FROM gforum_TriathlonsStates AS gts LEFT JOIN gforum_Triathlons AS gt ON gts.statetag = gt.statetag AND gt.date > '2008-01-01' GROUP BY gts.statetag ORDER BY gts.statetag ASC";**/ $sqlregionlist = "SELECT gtr.regionlong AS regionlong, gtr.regionid AS regionid, gtr.regionname AS regionname, gts.statetag AS statetag, gts.statelong AS statelong, COUNT(gr.retailer_id) AS numshops FROM gforum_TriathlonsStates AS gts LEFT JOIN gforum_Retailers AS gr ON gts.statetag = gr.retailer_state_tag AND gr.retailer_valid = 1 LEFT JOIN gforum_TriathlonsRegions AS gtr ON gts.regionid = gtr.regionid GROUP BY gtr.regionlong, gts.statetag ORDER BY gtr.regionlong ASC"; //$resultstatelist = mysql_query($sqlstatelist); $resultregionlist = mysql_query($sqlregionlist); ?>

Browse Retailers

$currentregion ($regioncount)$state_string"; echo ("
" . $currentregion . " (" . $regioncount . ")+
"); echo $tempstring; echo ("
\n"); } $currentregion = $rowregionlist[regionlong]; $currentrid = $rowregionlist[regionid]; $currenttag = $rowregionlist[regionname]; $regioncount = 0; $tempstring = ''; $state_string = ''; } if ($selected_item == $rowregionlist[statetag]) { $selected_state = ' selected="selected"'; } $state_string .= ""; $tempstring = $tempstring. "$rowregionlist[statelong] ($rowregionlist[numshops])\n"; $regioncount += $rowregionlist[numshops]; } echo ("
".$currentregion." (".$regioncount.")+
"); echo $tempstring; echo ('
'); if ( $selected_item == 'top') { $selected_region = ' selected="selected"'; } $region_dropdown .= ""; ?>
Search Retailers