".$x_years_ago." GROUP BY grr.rating_retailer_id HAVING COUNT(grr.rating_vote) > ".$min_number_of_votes." ORDER BY score DESC, votes DESC"); $top_retailers = array(); while($row = mysql_fetch_array($results)) { $row['weighted_score'] = $row['score']+$w_respondents*($row['respondents']); $row['weighted_score'] = $row['weighted_score']+$w_retailer_cart*($row['retailer_cart']); $row['weighted_score'] = $row['weighted_score']+$w_retailer_shopper_tags*substr_count($row['retailer_shopper_tags'], ','); $row['weighted_score'] = $row['weighted_score']+$w_retailer_fitbikes*substr_count($row['retailer_fitbikes'], ','); $row['weighted_score'] = $row['weighted_score']* $w_retailer_motioncapture+substr_count($row['retailer_motioncapture'], ','); $row['weighted_score'] = $row['weighted_score']+$w_retailer_wetsuits*substr_count($row['retailer_wetsuits'], ','); $row['weighted_score'] = $row['weighted_score']+$w_retailer_bikes*substr_count($row['retailer_bikes'], ','); $row['weighted_score'] = $row['weighted_score']+$w_retailer_fist_names*substr_count($row['retailer_fist_names'], ','); array_push($top_retailers, $row); } //sort the array by keyword match success instead of by date function cmp($a, $b) { if ($a['weighted_score'] == $b['weighted_score']) { return 0; } return ($a['weighted_score'] > $b['weighted_score']) ? -1 : 1; } usort($top_retailers, "cmp"); // set the page title $pagetitle = "Top Retailers"; // set meta tags $meta_keywords = "top ranked retailers"; $meta_description = "Top ranked triathlon retailers based on rankings submitted by the user."; ?>

Top Ranked Triathlon Retailers

These rankings are compiled based off Slowtwitch.com's own scoring algorithm. The individual ranking - by stars - of each shop is still shown. But the list's ranking and the score shown on this page is the Slowtwitch.com score for each retailer.

">
"> - ".$row[retailer_city].", ".$row[retailer_state]." -"; ?>