require_once('connection/kiswell_connection.php');
mysql_select_db($database_kiswell, $kiswell);
include ("news.php");
include ("date.php");
$query_Categorie="";
// On recupere le parametre cat pour la requete.
if (!isset($_REQUEST['cat']))
{
$arg="afro";
}else{
$arg=$_REQUEST['cat'];
}
// On recupere le parametre cat pour la pagination.
if (isset($_REQUEST['num']))
{
$num = $_REQUEST["num"];
$Ndeb=intval($num);
}else{
$num = 0;
}
$Nmax = 16;
$query_Categorie = "SELECT distinct categorie FROM kiswell_cat where url_pochette != '' ORDER BY categorie ASC ";
$query_Pochettes = "SELECT url_pochette ";
$query_Pochettes.=" FROM kiswell_cat WHERE categorie = '".$arg."' AND url_pochette !='' ORDER BY artiste,date_entree ASC ";
$total = mysql_query($query_Pochettes, $kiswell) or die(mysql_error());
$nb=mysql_num_rows($total);
// Nombre de page totale
$Npag = ceil($nb/$Nmax);
// n??saire ?la paginiaztion.
$query_Pochettes.=" LIMIT $num,$Nmax";
$result_Categorie = mysql_query($query_Categorie, $kiswell) or die(mysql_error());
$result_Pochettes = mysql_query($query_Pochettes, $kiswell) or die(mysql_error());
//$nb=mysql_num_rows($result_Categorie);
// Fonction permettant le parcours du dossier gallery
function parcours_arbo1($rep,$ssrep) {
$tab_Files = array ();
$cpt=1;
if( $dir = opendir($rep) ) {
while( FALSE !== ($fich = readdir($dir)) ) {
if ($fich != "." && $fich != ".." && $fich != "index.php") {
$chemin = "$rep$fich";
if (is_dir($chemin)) {
parcours_arbo1($chemin.'/', ($ssrep==''?$fich:$ssrep.'/'.$fich));
}
else
$tab_Files[$cpt] = $fich;
$cpt++;
//echo ($ssrep==''?$fich:$ssrep.'/'.$fich)."
";
}
}
}
return $tab_Files;
}
?>