Home > Gear Info'; $strPageBody = << OGE is built on proprietary technology that allows you to search a gear database with nearly 500,000 products, from over 70 of the best Outdoor Gear Stores on the web. Browse the most popular searches, products and stores below. Or review the latest entries from our Outdoor Blog, which include gear and apparel promotions, product reviews and outdoor industry news.

Top 100 Searches
$strTopTwentyFiveSearches
Top 100 Products
$strTopTwentyFiveProductPages
Top 25 Stores
$strTopTwentyFiveStores

Outdoor Blog Headlines

$strOgeBlogFeed
EOT; function getTopTwentyFiveProductPages() { global $mySQL_g; $strSQL = ' SELECT P.lngProductId, P.strProductName FROM tblProductPageStats PG INNER JOIN tblProduct P ON PG.lngProductId = P.lngProductId WHERE PG.dtmLastModified > DATE_SUB(NOW(), INTERVAL 30 DAY) ORDER BY PG.intProductViewCount DESC LIMIT 100 '; $arrProductStats = $mySQL_g->getAll($strSQL, null, DB_FETCHMODE_ASSOC); if (count($arrProductStats) > 0) { $strHtml = '
    '; for ($i=0; $i' . $arrProductStats[$i]['strProductName'] . ''; } $strHtml .= '
'; } return($strHtml); } function getTopTwentyFiveStores() { global $mySQL_g; $strSQL = ' SELECT SI.lngMerchantId, SI.strMerchantName FROM tblStoreInfo SI INNER JOIN tblStoreStats SS ON SI.lngMerchantId = SS.lngMerchantId ORDER BY SS.intStoreViewCount DESC LIMIT 25 '; $arrStoreStats = $mySQL_g->getAll($strSQL, null, DB_FETCHMODE_ASSOC); if (count($arrStoreStats) > 0) { $strHtml = '
    '; for ($i=0; $i' . $arrStoreStats[$i]['strMerchantName'] . ''; } $strHtml .= '
'; } return($strHtml); } function getTopTwentyFiveSearches() { global $mySQL_g; $strSQL = ' SELECT strSearchTerm FROM tblSearchStats WHERE dtmLastModified > DATE_SUB(NOW(), INTERVAL 30 DAY) ORDER BY intSearchCount DESC LIMIT 100 '; $arrSearchStats = $mySQL_g->getAll($strSQL, null, DB_FETCHMODE_ASSOC); if (count($arrSearchStats) > 0) { $strHtml = '
    '; for ($i=0; $i' . $arrSearchStats[$i]['strSearchTerm'] . ''; } $strHtml .= '
'; } return($strHtml); } require_once('./layout/template_v3.php'); ?>