".$minVotesNo." ORDER BY rate DESC LIMIT 15"; /* $query = "SELECT phone.idphone, CONCAT(brand.brand, ' ', phone.name) AS phone_full_name, phone.device_type_id, (phone.design + phone.features + phone.performance) / 3 AS rate, phone.votes_no, status.status FROM brand, phone, status WHERE brand.published = '1' AND phone.idbrand = brand.idbrand AND phone.published = '1' AND phone.votes_no > ".$minVotesNo." AND status.idstatus = phone.idstatus AND status.status LIKE 'available%' ORDER BY rate DESC LIMIT 15"; */ $result = mysql_query($query, $conn); if($result) { $i = 0; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $rated_phones[] = $row; if($i < 5) { $keywords[] = $row['phone_full_name']; $i++; } } } else { close_db($conn); echo "There seems to be a MySQL problem. Please try again later. Thank you."; exit(); } $query = "SELECT phone.idphone, CONCAT(brand.brand, ' ', phone.name) AS phone_full_name, phone.device_type_id, phone.hits_no FROM phone, brand WHERE brand.idbrand=phone.idbrand AND phone.hits_no>0 AND phone.published = '1' AND brand.published = '1' ORDER BY hits_no DESC LIMIT 15"; $result = mysql_query($query, $conn); if($result) { $i = 0; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $interest_phones[] = $row; if($i < 5) { $keywords[] = $row['phone_full_name']; $i++; } } } else { close_db($conn); echo "There seems to be a MySQL problem. Please try again later. Thank you."; exit(); } $query = "SELECT brand.idbrand, brand.brand, SUM((phone.design+phone.features+phone.performance)/3)/COUNT(*) AS rate, SUM(phone.votes_no) AS total_votes_no FROM brand, phone WHERE phone.idbrand=brand.idbrand AND phone.votes_no>$minVotesNo GROUP BY phone.idbrand ORDER BY rate DESC, brand.idbrand LIMIT 7"; $result = mysql_query($query, $conn); if($result) { $i = 0; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $rated_brands[] = $row; if($i < 5) { $keywords[] = $row['brand']; $i++; } } } else { close_db($conn); echo "There seems to be a MySQL problem. Please try again later. Thank you."; exit(); } $query = "SELECT brand.idbrand, brand.brand, SUM(phone.hits_no) AS total_hits_no FROM brand, phone WHERE phone.idbrand=brand.idbrand AND phone.hits_no>0 GROUP BY phone.idbrand ORDER BY total_hits_no DESC LIMIT 7"; $result = mysql_query($query, $conn); if($result) { $i = 0; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $interest_brands[] = $row; if($i < 5) { $keywords[] = $row['brand']; $i++; } } } else { close_db($conn); echo "There seems to be a MySQL problem. Please try again later. Thank you."; exit(); } $keywords = implode(",", array_unique($keywords)); $brands_menu = db_get_brands_main($conn); close_db($conn); $html_meta_title = "Mobile phones statistics"; $html_meta_desc = "Mobile phones statistics on ".SITE_NAME; $html_meta_keywords = $keywords.",rankings,statistics,rate,interest,votes,hits"; include_once("./include/header.inc.php"); ?>

Statistics

hits Info pages* served since May, 2007

SITE_NAME - Current rankings

$val_arr) { $i++; $phoneNameID = make_user_friendly($val_arr['phone_full_name']); ?>
By rate
  Phones Rate Votes
.