header('Location: http://www.victorkiswell.com/v3/'); exit(); require_once('connection/kiswell_connection.php'); mysql_select_db($database_kiswell, $kiswell); include ("news.php"); include ("date.php"); $query_Categorie=""; // Nombre de jours à partir duquel on supprime les fichiers $nb_jours = 30; // On recupere le parametre cat pour la requete. if (!isset($_REQUEST['cat'])) { $arg="library music"; }else{ $arg=$_REQUEST['cat']; } // On recupere les param necessaire au tri par date. if (!isset($_REQUEST['tridate'])) { $tridate="DESC"; }else{ $tridate=$_REQUEST['tridate']; if ($tridate=="ASC") { $tridate="DESC"; }else{ $tridate="ASC"; } } if (!isset($_REQUEST['trialpha'])) { $trialpha=""; }else{ $trialpha=$_REQUEST['trialpha']; if ($trialpha=="ASC") { $trialpha="DESC"; }else{ $trialpha="ASC"; } } // On recupere le parametre cat pour la pagination. if (isset($_REQUEST['num'])) { $num = $_REQUEST["num"]; $Ndeb=intval($num); }else{ $num = 0; } $Nmax = 15; $query_Categorie = "SELECT distinct categorie FROM kiswell_cat ORDER BY categorie ASC "; $query_Albums = "SELECT `artiste`, `titre`, `prix`, `label`, `pays`, `annee`, `format`, `condition`, `description`, `url_pochette`, `url_son`, `categorie`, DATE(`date_entree`) as date_entree "; $query_Albums.=" FROM kiswell_cat WHERE categorie = '".$arg."' "; //echo $query_Albums; if ($trialpha!="") { $query_Albums.=" ORDER BY artiste ".$trialpha; }else{ $query_Albums.=" ORDER BY date_entree ".$tridate; } $total = mysql_query($query_Albums, $kiswell) or die(mysql_error()); $nb=mysql_num_rows($total); // Nombre de page totale $Npag = ceil($nb/$Nmax); // n??saire ?la paginiaztion. $query_Albums.=" LIMIT $num,$Nmax"; $result_Categorie = mysql_query($query_Categorie, $kiswell) or die(mysql_error()); $result_Albums = mysql_query($query_Albums, $kiswell) or die(mysql_error()); //$nb=mysql_num_rows($result_Categorie); ?>