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 35
| if(!isset($_SESSION['tri']))
{
$_SESSION['tri'] = 'ref'; // Valeur par défaut pour le tri
}
if(isset($_GET['tri']))
{
$_SESSION['tri'] = $_GET['tri'];
}
$sql = 'SELECT * FROM catalogue ';
switch($_SESSION['tri'])
{
case 'ref':
$sql .= 'ORDER BY ref');
break;
case 'ess':
$sql .= 'ORDER BY essence, ref');
break;
case 'classe':
$sql .= 'WHERE essence=\''.$super.'\' ORDER BY echelle, ref';
break;
case 'eche':
$sql .= 'ORDER BY echelle, ref';
break;
default:
$sql .= 'ORDER BY echelle, ref';
break;
}
$req1 = mysql_query($sql); |