$host="localhost";
$user="root";
$pass="daniel090";
$db="scoala";

$id=$_GET['id'];

$gen=$_GET['gen'];

$nr=$_GET["nr"];

$conn=mysqli_connect($host,$user,$pass) or die("Nu ma pot conecta la baza de date");

mysqli_select_db($conn , $db) or die ("Nu gasesc baza de date");



 $query_meniu_orizontal=mysqli_query($conn,"SELECT * FROM meniu_orizontal_pg WHERE id='$id'");

 $query_meniu_lateral=mysqli_query($conn,"SELECT  * FROM meniu_lateral_pg WHERE name='$gen'");



  while($result1=mysqli_fetch_array($query_meniu_orizontal)){


         include ($result1['Pagina']);

      }

  while($result2=mysqli_fetch_array($query_meniu_lateral)){
        include ($result2['link']);
      }



mysqli_select_db($conn , $db) or die ("Nu gasesc baza de date");


        ?>
   </article>




     <!--SCRIPT DE PAGINARE-->



<?php






  //Selectam articolele din baza de date
  $query=mysqli_query($conn,"SELECT * FROM $gen ");
  $num_rows=mysqli_num_rows($query);


   while($articole=mysqli_fetch_array($query)){
          echo "<a href=\"index.php?nr=$articole[id]\">Filmul a</a>";
       if(isset($nr)){
                include ("Filme/$articole[nume_film]") ;
        //REZOLVAREA PENTRU INCLUDEREA PAGINILOR IN CATEGORIE ! DE PUS IN SCRIPTUL DE PAGINARE
         }


      }