//Classement des sites par nombre de clics dans PHPMyAnnu include("data_bd_annu.php3"); //variables de l'annuaire include("functions.php3"); //fonctions de l'annuaire $pag="Top_clics"; ?>
| Top clics |
|
//script permettant d'afficher les meilleurs sites ayant eu le plus de visites
//creation de la requete d'admin
$sql_admin = "SELECT nb_sites_in_topclics, nb_days2benew FROM $T_infos ";
//connexion a la BD
$lk = connection_BD();
//envoi de la requete
$res_admin = send_sql($sql_admin,"trouver le nombre de sites que contiendra le Top clics");
//traitement du resultat
$result_admin = mysql_fetch_array($res_admin,MYSQL_ASSOC);
$nb_sites_top_clics = $result_admin["nb_sites_in_topclics"];
$nb_days2benew = $result_admin["nb_days2benew"];
//creation de la requete pour les sites
$sql = "SELECT s.id, id_cat, titre, description, url, nb_clics, date_validation, cat_name, TO_DAYS(CURRENT_DATE) - TO_DAYS(date_validation) AS dif_days FROM $T_sites AS s, $T_categories AS c WHERE s.id_cat = c.id AND s.activation = 1 AND c.activation = 1 AND nb_clics > 0 ORDER BY nb_clics DESC,titre LIMIT 0,$nb_sites_top_clics";
//envoi de la requete
$res = send_sql($sql,"trouver les sites du Top clics");
//fin de la connexion
mysql_close($lk);
?>
if (mysql_num_rows($res)) //si on a des resultats { echo " } include ("bas.php3"); //pied de la page ?> |