include("secret/db_inc.php3");
@mysql_connect("$db_server","$db_user","$db_pw") or die("connect");
@mysql_select_db ("$db") or die("select");
$requeteNum="SELECT * FROM menuGroupe ORDER BY tri";
$requeteDetail="SELECT * FROM menu WHERE ssgroupe_gene='$groupe'ORDER BY tri";
$requeteNumero="SELECT * FROM menu GROUP BY numero ORDER BY numero " ;
$resultatPrincipal=CreerMenuPrincipal($requeteNum);
$motif=" ";
$rep="%20";
echo "
La Gazette de l'île Barbe";
echo "Table des articles";
echo "
";
while ($temp = @mysql_fetch_array($resultatPrincipal)) {
$lien=ereg_replace($motif,$rep,$temp[2]);
if ($temp[1]=="1") {
$lien="articles.php?groupe=$lien&num=$temp[3]";
echo "";
echo "- ".$temp[2]."";
if ($temp[3]==$num){
$groupe=ereg_replace("%20"," ",$groupe);
$resultatDetail=CreerMenu($requeteDetail);
while ($tempD = @mysql_fetch_array($resultatDetail)) {
echo "
- ".$tempD[0]."
";
}
}
}
else {
if ($temp[1]=="2") {
$lien="articles.php?groupe=$lien&num=$temp[3]";
echo "- ".$temp[2]."";
if ($num==$temp[3]) {
$groupe=ereg_replace("%20"," ",$groupe);
$resultat=CreerMenu($requeteDetail);
echo "";
while ($tempD = @mysql_fetch_array($resultat)) {
echo "
- ".$tempD[0]."
";
}
}
}
}
}
echo "
";
function CreerMenuPrincipal($requeteNum) {
$res = @mysql_query("$requeteNum") or die("resultat");
return $res;
}
function CreerMenu($requeteNum) {
$res = @mysql_query("$requeteNum") or die("resultat");
return $res;
}
?>
Recherche par numéro :
php3;
if (empty($num)) {}
else
{
echo "Articles du numéro ".$num." ";
$QueryRechNum="SELECT * FROM Xref_art_num WHERE numero=$num";
$res_Xref = @mysql_query("$QueryRechNum") or die("resultat_num");
while ($temp = @mysql_fetch_array($res_Xref))
{
$QueryDispNum="SELECT * FROM menu WHERE tri=$temp[1]";
$res_menu = @mysql_query("$QueryDispNum") ;
while ($temp1 = @mysql_fetch_array($res_menu)) {echo "
$temp1[0]";}
}
}
?>