1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| $tri=$_GET['tri'];
if ($_SESSION['tri']='ref'){
include("secret_catalogue.php?tri=ref"); //***
}
elseif ($_SESSION['tri']='ess'){
include("secret_catalogue.php?tri=ess");
}
elseif ($_SESSION['tri']='ess2'){
include("secret_catalogue.php?tri=ess2");
}
else{
include("secret_catalogue.php?tri=eche");
}
switch($tri){
case "ref":
$_SESSION['tri'] = 'ref';
$req1 = mysql_query("SELECT * FROM catalogue ORDER BY ref") or die ('ERREUR TRI REF<br>'. mysql_error());
break;
case "ess":
$_SESSION['tri'] = 'ess';
$req1 = mysql_query("SELECT * FROM catalogue ORDER BY essence,ref") or die ('ERREUR TRI ESSENCE<br>'. mysql_error());
break;
case "classe":
$_SESSION['tri'] = 'ess2';
$req1 = mysql_query("SELECT * FROM catalogue WHERE essence='$super' ORDER BY echelle,ref") or die ('ERREUR TRI ESSENCE 2<br>'. mysql_error());
break;
case "eche":
$_SESSION['tri'] = 'eche';
$req1 = mysql_query("SELECT * FROM catalogue ORDER BY echelle,ref") or die ('ERREUR TRI<br>'. mysql_error());
break;
default:
$req1 = mysql_query("SELECT * FROM catalogue ORDER BY echelle,ref") or die ('ERREUR TRI<br>'. mysql_error());
break;
} |