<? 

//.........ccsi web site for girls section ..\\

//.....برمجة   : Yasmin Al-Dosari ...........\\

//........ارجوا عدم ازالة الحقوق ............\\

//......... Copyright © 2005 Yasmin  ........\\

define("prog_path","/data/websites/iuccsi.com/www/");

include"config.php";

include_once "lib/db.php";

include_once "lib/smarty.php";

include "header.php";

	  
  $idsub=$_REQUEST['id'];		

  $sql="select * from subjects where id=?";

	  $vars[]=$idsub;

	  $r=db_query($sql,$vars);


  $sql2="select id,title,date,tname  from tnews  where ids=? order by id desc ";

	  $vars2[]=$idsub;

	  $r2=db_query($sql2,$vars2);

			$start=0;	

			$end2=sizeof($r2);

	    if ($end2>5) $end2=5;

	     $result2=array_slice($r2,$start,5);


  $sql3="select id,name,date,tname from homeworks  where id_sub=? order by id desc";

	  $vars3[]=$idsub;

	  $r3=db_query($sql3,$vars3);

			$start=0;	

			$end3=sizeof($r3);

	    if ($end3>3) $end2=3;

	     $result3=array_slice($r3,$start,3);

		
  $sql4="select id,name,date,tname from lecteur  where id_sub=? order by id desc";

	  $vars4[]=$idsub;

	  $r4=db_query($sql4,$vars4);

			$start=0;	

			$end4=sizeof($r4);

	    if ($end4>3) $end4=3;

	     $result4=array_slice($r4,$start,3);

		
 $sql5="select id,name,date,stname from slove  where id_sub=? order by id desc";

	  $vars5[]=$idsub;

	  $r5=db_query($sql5,$vars5);

			$start=0;	

			$end5=sizeof($r5);

	    if ($end5>3) $end5=3;

	     $result5=array_slice($r5,$start,3);	

		
   $sql6="select id,title,date,tname from st_news where ids=? order by id desc ";

	  $vars6[]=$idsub;

	  $r6=db_query($sql6,$vars6);

		if (sizeof($r6)==0 )

			$start=0;	

			$end6=sizeof($r6);

	    if ($end6>5) $end6=5;

	     $result6=array_slice($r6,$start,5);

		
  $s = new MySmarty;

	$s->assign('r',$r);

	$s->assign('r2',$result2);

	$s->assign('r3',$result3);

	$s->assign('r4',$result4);

	$s->assign('r5',$result5);

	$s->assign('r6',$result6);						

	$s->display('class.tpl');

	
include "footer.php";

?>