Web Developpement

    if (empty($page)) { $page = 1; }
    $debut = ($page - 1) * $nb_sites_on_page;
    $sql_descr = "SELECT texte FROM $T_categories WHERE id = '$cat_id' ";
    $sql_nb_sites = "SELECT id FROM $T_sites WHERE id_cat = '$cat_id' AND activation = 1 ";
    $sql_site = "SELECT *,TO_DAYS(CURRENT_DATE) - TO_DAYS(date_validation) AS dif_days FROM $T_sites WHERE id_cat = '$cat_id' AND activation = 1 ORDER BY niveau ASC,titre ASC LIMIT $debut,$nb_sites_on_page";
    $sql_scat = "SELECT id, cat_name FROM $T_categories WHERE id_cat_mere = '$cat_id' AND activation = 1 ORDER BY cat_name ASC";
    $res_descr = send_sql($sql_descr,"trouver la description de cette catégorie");
    $res_nb_sites = send_sql($sql_nb_sites,"trouver le nombre de sites à afficher");
    $res_site = send_sql($sql_site,"trouver les sites à afficher");
    $res_scat = send_sql($sql_scat,"trouver les sous-catégories");
    $nb_sites = mysql_num_rows($res_nb_sites);
    $nb_pages = ceil($nb_sites / $nb_sites_on_page);
    echo "<br />".show_arbo_en_ligne($cat_id)."<br />\n";
    if (mysql_num_rows($res_scat)) {
        ?>
    <table style="width:90%;border:none;text-align:center;">
      <tr>
        <td>&nbsp;</td>
        <?php
        $i=0;
        while ($resultat = mysql_fetch_array($res_scat,MYSQL_ASSOC))
        {
            if ($i%2 == 0)
                echo "</tr>\n<tr>\n";
            echo "<td style=\"width:55%;height:30px;text-align:center;\">\n";
            ?>
        <img src="images/dossier.gif" style="border:0;" alt="" />
        <?php
            $phrase = $resultat["cat_name"];
            $masque = array("."," - "," & ","&","'",",","(",")","À","Á","Â","Ã","Ä","Å","à","á","â","ã","ä","å","Ò","Ó","Ô","Õ","Ö","Ø","ò","ó","ô","õ","ö","ø","È","É","Ê","Ë","è","é","ê","ë","Ç","ç","Ì","Í","Î","Ï","ì","í","î","ï","Ù","Ú","Û","Ü","ù","ú","û","ü","ÿ","Ñ","ñ"," ","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
            $ok_masque = array("","-","-","-","-","-","","","a","a","a","a","a","a","a","a","a","a","a","a","o","o","o","o","o","o","o","o","o","o","o","o","e","e","e","e","e","e","e","e","c","c","i","i","i","i","i","i","i","i","u","u","u","u","u","u","u","u","y","n","n","-","a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z");
            $newphrase = str_replace($masque, $ok_masque, $phrase);
            ?>
        <a href="<?php echo $resultat["id"]; ?>-<?php echo $newphrase3; ?>-<?php echo $newphrase; ?>.html" class="link_scat_other_annuaire"><?php echo htmlspecialchars($resultat["cat_name"]); ?></a>
        <?php if ($nblien == "oui") { ?>
        <small><span class="nb_scat_other_annuaire">(<?php echo get_nbsites($resultat["id"]); ?>)</span>
        <?php } ?></small>
        <?php
            echo "</td>\n";
            $i++;
        }
        if ($i%2 != 0)
            echo "</tr><tr><td style=\"width:55%;height:30px;text-align:center;\">&nbsp;</td>\n";
        ?>
      </tr>
    </table>
    <hr />
    <?php
    }
    mysql_close($lk);
    $res_texte = mysql_fetch_array($res_descr,MYSQL_ASSOC);
    if ($res_texte["texte"]) {
        ?>
    <span class="text_cat_annuaire">
    <?php
        echo $res_texte["texte"];
        ?>
    </span> <br />
    <br />
    <?php
    }
    if ($page == 1) {
      $searchrecherche=str_replace(" ","-",$titre);
        $cle="?search=".$searchrecherche;
        if ($searchrecherche!="" and $di =="oui") {@include ("page.php");}
      }
    if (mysql_num_rows($res_site)) {
        ?>
    <!-- <table width="100%" border=0 align="center"> -->
    <div align="center"><?php
$count_pub = 0;

while ($resultat = mysql_fetch_array($res_site,MYSQL_ASSOC))
{
if($count_pub == '3')
{

echo "<div align=\"center\"><script type=\"text/javascript\"><!--
google_ad_client =\"pub-4870871263361368\";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format =\"468x60_as\";
google_ad_type =\"text\";
google_ad_channel =\"\";
google_color_border =\"FFFFFF\";
google_color_bg =\"FFFFFF\";
google_color_link =\"7CB5D3\";
google_color_text =\"000000\";
google_color_url =\"1564b2\";
//-->
</script>
<script type=\"text/javascript\"
src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">
</script></center";
echo "<br /><br /><br />";
}

affiche_site2($resultat,'index');

     $sql_site = "
         CREATE TABLE $T_sites (
         id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
         id_cat MEDIUMINT UNSIGNED NOT NULL,
         titre VARCHAR (100) NOT NULL,
         titre2 VARCHAR (100) NULL,
         titre3 VARCHAR (100) NULL,
         description VARCHAR (255) NOT NULL,
         url VARCHAR (150) NOT NULL,
         url_rss VARCHAR (150) NULL,
         nom_proprio VARCHAR (50) NOT NULL,
         email_proprio VARCHAR (75) NOT NULL,
         date_validation DATE NOT NULL,
         activation TINYINT(1) DEFAULT '1' NOT NULL,
         niveau TINYINT(1) UNSIGNED DEFAULT '5' NOT NULL,
         nb_clics MEDIUMINT UNSIGNED DEFAULT '0' NOT NULL,
         moyenne_votes DECIMAL (4,2) UNSIGNED DEFAULT '0.00' NOT NULL,
         nb_votes MEDIUMINT UNSIGNED DEFAULT '0' NOT NULL,
         nb_com MEDIUMINT UNSIGNED DEFAULT '0' NOT NULL,
         UNIQUE(id_cat,url) ) ";