include "../connect.php";
$sect = $_GET['sect'];
$start = intval($_GET['start']);
$perpage = 30;
if (($sect >0)&&($sect < 110)) {$sectchars=0;} else {$sectchars=1;}
if ($sectchars==0) {
$qwery1 = "select * from AniSections where no='$sect'";
$res1=mysql_query($qwery1);
while ($row1=mysql_fetch_row($res1)){
$sect_name=$row1[2];
$ss=$row1[1];;
}
}
if ($sectchars==1) {
$qwery1 = "select * from AniSections where section ='$sect'";
$res1=mysql_query($qwery1);
while ($row1=mysql_fetch_row($res1)){
$sect_name=$row1[2];
$ss=$row1[1];;
}
}
echo "
$sect_name";
include "head.inc";
?>
$qwery = "select * from Anecdots where section='$ss'";
$res=mysql_query($qwery);
$cou=mysql_num_rows($res);
echo " Всего анекдотов этой тематики - $cou";
?>
|
Ведущий раздела: Александр Захаров
|
echo "$sect_name
";
if (!$start) {$start=0;}
$perpage=30;
$i=0;
$next=1;
$ii=0;
echo "| ";
while ($i<=$cou){
$i=$i+$perpage;
$nexttmp=$next-1;
$ii=$ii+1;
if ($start==$nexttmp) {echo "$ii \n";} else {
echo "$ii \n";}
$next=$next+$perpage;
}
echo " |
";
$qwery = "select * from Anecdots where section='$ss' order by no desc limit $start, $perpage";
$res=mysql_query($qwery);
while ($row=mysql_fetch_row($res)){
if ($row[2]){$author="Авторство: ".$row[2]."
";} else {$author="";}
if ($row[3]){$author="Источник: ".$row[3]."
";} else {$source="";}
if ($row[6]){$title="".$row[6]."
";} else {$title="";}
echo "";
echo "| Анекдот №".$row[0]." [$sect_name] |
";
$day=substr($row[5], 6,2);
$month=substr($row[5], 4,2);
$year=substr($row[5], 0,4);
echo "| ".$title.$row[4]." ".$author.$source.$day.".".$month.".".$year." |
";
echo "

";
}
$i=0;
$next=1;
$ii=0;
echo "| ";
while ($i<=$cou){
$i=$i+$perpage;
$nexttmp=$next-1;
$ii=$ii+1;
if ($start==$nexttmp) {echo "$ii \n";} else {
echo "$ii \n";}
$next=$next+$perpage;
}
echo " |
";
include "foot.inc";
?>