Форум программистов [Powered by Invision Power Board]

Код

function navigation ($letter1,$letter2,$letter3,$r1,$r2,$limit)
{

$ath=mysql_query("SELECT * FROM films WHERE name like '&#$letter1%' or name like '&#$letter2%' or name like '$letter3' ORDER BY `name` ASC");
    $count = mysql_num_rows($ath);
    $ath=mysql_query("SELECT * FROM films WHERE name like '&#$letter1%' or name like '&#letter2%' or name like '$letter3' ORDER BY `name` ASC LIMIT $limit, 30");
    $page=floor($count/30);
    $rest=$count%30;
    if ($rest>0){$page=$page+1;}
    if ($r1>=10){echo "<a href=\"Index.php?func=navigation&letter1=".$letter1."&letter2=".$letter2."&letter3=".$letter3."&r1=".($rr1=$r1-10)."&r2=".($rr2=$r2-10)."&limit=".($r1*3)."\"><< </a> "; }
    for ($i = $r1; ($i <= $r2)and($i < $page);$ar[$i]="Index.php?func=navigation&letter1=".$letter1."&letter2=".$letter2."&letter3=".$letter3."&r1=".$r1."&r2=".$r2."&limit=".($i*30),print "<a href=\"$ar[$i]\">".($i+1)." </a>", $i++);
    if ($r2<($page-1)){echo "<a href=\"Index.php?func=navigation&letter1=".$letter1."&letter2=".$letter2."&letter3=".$letter3."&r1=".($r1=$r1+10)."&r2=".($r2=$r2+10)."&limit=".(($r2-9)*30)."\">>></a> ";}

 echo "</td></tr></table><br><br>";
      
  if($ath){
  echo "<table cellspacing='0' class='table2'>";
  while ($autor=mysql_fetch_array($ath))
  {
          echo "<tr><td class='bott' 1width=\"100%\">".$autor['name']."&nbsp;/ ".$autor['genre']."&nbsp / ".$autor['year']."&nbsp;</td></tr>
                <tr><td class='bott' >".$autor['actor']."&nbsp;</td></tr>";
  }
  echo "</table><br><br>";
  }
  else
  {
          echo "<p><b>Error:".mysql_error()."</b><p>";
          exit();
  }