Nous vous proposons actuellement sites.
N'hésitez pas à nous proposez votre site,
ou bien un site qui a particulièrement retenu votre attention !
Légende :
 : Site professionel.
 : Site amateur.
|
0)
{
for ($i=$nb_col; $i<$nb_col_max; $i++)
{
print(" | | \n");
}
print("
\n");
}
}
function affiche_lien($val)
{
global $largeur_col;
print(" \n");
print(" \n");
if (time()-$val[8]<15*24*3600)
{print(" ![](\"/img/new.gif\") \n");}
else
{print(" ![\"\"](\"img/format_url.gif\") \n");}
print(" $val[3]\n");
print(" | \n");
$largeur_desc=(2*$largeur_col)-30;
$val[4]=stripslashes($val[4]);
print(" \n");
print(" $val[4]\n");
print(" | \n");
if ($val[6]<>"")
{print(" ![\"$val[6]\"](\"/img/drapeau_$val[6].gif\") | \n");}
else{print(" | \n");}
if ($val[7]<>"")
{print(" ![](\"/img/liens/$val[7].gif\") | \n");}
else{print(" | \n");}
print("
\n");
}
if (isset($sous_cat) AND isset($cat))
{
print("\n");
print(" \n");
print(" | Départ >\n");
$requete_cat ="SELECT * FROM liens_categories ";
$requete_cat.="WHERE ID LIKE '$cat' ORDER BY nom";
$val=mysql_fetch_row(mysql_query($requete_cat));
print(" $val[1] >");
$requete_sous_cat ="SELECT * FROM liens_sous_categories ";
$requete_sous_cat.="WHERE categorie LIKE '$cat' ";
$requete_sous_cat.="AND ID LIKE '$sous_cat'";
$val=mysql_fetch_row(mysql_query($requete_sous_cat));
print(" $val[2]\n");
print(" | \n");
print("
\n");
print("
\n");
$requete ="SELECT * FROM liens_listes ";
$requete.="WHERE categorie LIKE '$cat' ";
$requete.="AND sous_categorie LIKE '$sous_cat' ORDER BY nom";
$resultat=mysql_query($requete);
print("\n");
while ($val=mysql_fetch_row($resultat))
{
affiche_lien($val);
}
print("
\n");
}
else if (isset($cat))
{
print("\n");
print(" \n");
print(" | Départ >\n");
$requete_cat ="SELECT * FROM liens_categories ";
$requete_cat.="WHERE ID LIKE '$cat' ORDER BY nom";
$val=mysql_fetch_row(mysql_query($requete_cat));
print(" $val[1]");
print(" | \n");
print("
\n");
print("
\n");
$requete ="SELECT * FROM liens_sous_categories ";
$requete.="WHERE categorie LIKE '$cat' ORDER BY nom";
$resultat=mysql_query($requete);
if (mysql_num_rows($resultat)>0)
{
print("\n");
while ($val=mysql_fetch_row($resultat))
{
$requete_nb_rec ="SELECT * FROM liens_listes ";
$requete_nb_rec.="WHERE categorie LIKE '$cat' ";
$requete_nb_rec.="AND sous_categorie LIKE '$val[0]' ORDER BY nom";
$nb_rec=mysql_num_rows(mysql_query($requete_nb_rec));
if ($nb_rec>0)
{
if ($nb_col==0)
{
print(" \n");
}
print(" \n");
print(" ![\"\"](\"img/liens/dossier.gif\") \n");
print(" $val[2] ($nb_rec)\n");
print(" | \n");
$nb_col++;
if ($nb_col==$nb_col_max)
{
print("
\n");
$nb_col=0;
}
}
}
fin_tableau();
print("
\n");
}
$nb_col=0;
$requete ="SELECT * FROM liens_listes ";
$requete.="WHERE categorie LIKE '$cat' ";
$requete.="AND sous_categorie LIKE '0' ORDER BY nom";
$resultat=mysql_query($requete);
if (mysql_num_rows($resultat)>0)
{
print("
\n");
print("\n");
while ($val=mysql_fetch_row($resultat))
{
affiche_lien ($val);
}
print("
\n");
}
}
else
{
print("\n");
print(" \n");
print(" | Départ | \n");
print("
\n");
print("
\n");
$requete="SELECT * FROM liens_categories ORDER BY nom";
$resultat=mysql_query($requete);
$nb_rec=mysql_num_rows($resultat);
print("\n");
while ($val=mysql_fetch_row($resultat))
{
$requete_nb_rec ="SELECT * FROM liens_listes ";
$requete_nb_rec.="WHERE categorie LIKE '$val[0]'";
$nb_rec=mysql_num_rows(mysql_query($requete_nb_rec));
if ($nb_rec>0)
{
if ($nb_col==0)
{print(" \n");}
print(" | \n");
print(" \n");
print(" $val[1] ($nb_rec)\n");
print(" | \n");
$nb_col++;
if ($nb_col==$nb_col_max)
{
print("
\n");
$nb_col=0;
}
}
}
fin_tableau();
print("
\n");
}
if (!isset($cat))
{
print("
\n");
print("Les 4 derniers sites enregistrés :
\n");
$requete ="SELECT * FROM liens_listes ORDER BY ID DESC LIMIT 0,4 ";
$resultat=mysql_query($requete);
print("\n");
while ($val=mysql_fetch_row($resultat))
{
affiche_lien ($val);
}
print("
\n");
}
mysql_close();
?>
