Да показва по 3-4 игри на ред КАК ?

H

haughtelf

Registered
Код: 
<?php
$pp = "9"; 
//колко резултата на страница 
$page=$_GET['page'];
if(!$_GET['page'])
{ 
$page="1"; 
} 
$limit = ($pp*$page)-$pp;
mysql_connect($dbhost, $dbusername, $dbpassword)or die("1111"); 
@mysql_select_db($dbname) or die("2222"); 
$redove=mysql_query("SELECT * FROM $table_name"); 
$max=mysql_numrows($redove);
$total=ceil($max/$pp);
mysql_connect($server, $dbusername, $dbpassword)or die("3333"); 
@mysql_select_db($dbname) or die("4444"); 
$query="SELECT * FROM $table_name WHERE kategoria='Забавни' ORDER BY id DESC LIMIT $limit,$pp"; 
$result=mysql_query($query); 
$num=mysql_num_rows($result);
mysql_close(); 
echo "<table border='0'><tr><td>"; 
$i=0; 
while ($i < $num) { 
$ime=mysql_result($result,$i,"ime"); 
$pic=mysql_result($result,$i,"pic"); 
$kategoria=mysql_result($result,$i,"kategoria"); 
$id=mysql_result($result,$i,"id");
echo "<div class='div'>
<a href='play.php?id=$id'>$ime</a><br>
<a href='play.php?id=$id'><img src='$pic' width='100' height='100' border='0'></a><br>
<br></div>
"; 
$i++; 
} 
echo "</td</tr></table>";
//от тук започва страницирането
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"?page=$prev\" class='ppRa'>предишна</a> "; 
} 
else echo ""; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<b>$i</b> "; 
} 
else { 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<b>$i</b>"; 
} 
else { 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a href=\"?page=4\" class='ppRa'>4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
if ($page == 5) $parva.= "<a href=\"?page=4\" class='ppRa'>4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"?page=$next\" class='ppRa'>следваща</a>"; 
} 
else echo "";
?>
</tr>
</table>
 
<?php
$pp = "9";
//колко резултата на страница
$page=$_GET['page'];
if(!$_GET['page'])
{
$page="1";
}
$limit = ($pp*$page)-$pp;
mysql_connect($dbhost, $dbusername, $dbpassword)or die("1111");
@mysql_select_db($dbname) or die("2222");
$redove=mysql_query("SELECT * FROM $table_name");
$max=mysql_numrows($redove);
$total=ceil($max/$pp);
mysql_connect($server, $dbusername, $dbpassword)or die("3333");
@mysql_select_db($dbname) or die("4444");
$query="SELECT * FROM $table_name WHERE kategoria='Забавни' ORDER BY id DESC LIMIT $limit,$pp";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
echo "<table border='0'><tr><td>";
$i=0;
while ($i < $num) {
$i++
$ime=mysql_result($result,$i,"ime");
$pic=mysql_result($result,$i,"pic");
$kategoria=mysql_result($result,$i,"kategoria");
$id=mysql_result($result,$i,"id");
echo "<div class='div'>
<a href='play.php?id=$id'>$ime</a><br>
<a href='play.php?id=$id'><img src='$pic' width='100' height='100' border='0'></a><br>
<br></div>
";


echo "</td";
if($i == 4) {echo '</tr>';}
}
echo "</table>";

//от тук започва страницирането
Увеличете...
така трябва да стане ;)
 
Код: 
<?php
$pp = "9";
//колко резултата на страница
$page=$_GET['page'];
if(!$_GET['page'])
{
$page="1";
}
$limit = ($pp*$page)-$pp;
mysql_connect($dbhost, $dbusername, $dbpassword)or die("1111");
@mysql_select_db($dbname) or die("2222");
$redove=mysql_query("SELECT * FROM $table_name");
$max=mysql_numrows($redove);
$total=ceil($max/$pp);
mysql_connect($server, $dbusername, $dbpassword)or die("3333");
@mysql_select_db($dbname) or die("4444");
$query=mysql_query("SELECT * FROM $table_name WHERE kategoria='Забавни' ORDER BY id DESC LIMIT $limit,$pp");
mysql_close();
echo "<table border='0'>";
$i=0;
while ($num=mysql_fetch_array($query)) {
$i++
$ime=$num['ime'];
$pic=$num['pic'];
$kategoria=$num["kategoria"];
$id=$num["id"];
echo "<tr><td><div class='div'>
<a href='play.php?id=$id'>$ime</a><br>
<a href='play.php?id=$id'><img src='$pic' width='100' height='100' border='0'></a><br>
<br></div></td>";
if($i == 4) {echo '</tr>';}
}
echo "</table>";

//от тук започва страницирането
а така ???

промених ти малко заявката да знаеш ;)
 
Код: 
<?php
$pp = "9"; 
//колко резултата на страница 
$page=$_GET['page']; 
if(!$_GET['page']) { 
	$page="1"; 
}

$limit = ($pp*$page)-$pp; 
mysql_connect($dbhost, $dbusername, $dbpassword)or die("1111"); 
@mysql_select_db($dbname) or die("2222"); 
$redove=mysql_query("SELECT * FROM $table_name"); 
$max=mysql_numrows($redove); 
$total=ceil($max/$pp); 
mysql_connect($server, $dbusername, $dbpassword)or die("3333"); 
@mysql_select_db($dbname) or die("4444"); 
$query="SELECT * FROM $table_name WHERE kategoria='Забавни' ORDER BY id DESC LIMIT $limit,$pp"; 
$result=mysql_query($query); 
$num=mysql_num_rows($result); 
mysql_close(); 
?>
<table border='0'>
	<?php
	$i=0; 
	while ($i < $num) { 
		$ime=mysql_result($result,$i,"ime"); 
		$pic=mysql_result($result,$i,"pic"); 
		$kategoria=mysql_result($result,$i,"kategoria"); 
		$id=mysql_result($result,$i,"id"); 
		if($i % 4 == 0) {
			?>
			<tr>
			<?php
		}
		?>
			<td>
				<div class='div'> 
					<a href='play.php?id=<?php echo $id; ?>'><?php echo $ime; ?></a><br /> 
					<a href='play.php?id=<?php echo $id; ?>'><img src='<?php echo $pic; ?>' width='100' height='100' border='0'></a><br /><br />
				</div>
			</td>
		<?php
		$i++;
	}
	?>
	</tr>
</table>
<?php
//от тук започва страницирането 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"?page=$prev\" class='ppRa'>предишна</a> "; 
} 
else echo ""; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<b>$i</b> "; 
} 
else { 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<b>$i</b>"; 
} 
else { 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a href=\"?page=4\" class='ppRa'>4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
if ($page == 5) $parva.= "<a href=\"?page=4\" class='ppRa'>4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"?page=$next\" class='ppRa'>следваща</a>"; 
} 
else echo ""; 
?> 
</tr> 
</table>
 
Код: 
<table border='0'> 
   <?php 
   $i=0; 
   while ($i < $num) { 
      $ime=mysql_result($result,$i,"ime"); 
      $pic=mysql_result($result,$i,"pic"); 
      $kategoria=mysql_result($result,$i,"kategoria"); 
      $id=mysql_result($result,$i,"id"); 
      if($i % 4 == 0) { 
         ?> 
         <tr> 
         <?php 
      } 
      ?> 
         <td> 
            <div class='div'> 
               <a href='play.php?id=<?php echo $id; ?>'><?php echo $ime; ?></a><br /> 
               <a href='play.php?id=<?php echo $id; ?>'><img src='<?php echo $pic; ?>' width='100' height='100' border='0'></a><br /><br /> 
            </div> 
         </td> 
      <?php 
      $i++; 
   } 
   ?> 
   </tr> 
</table>

Сравни го с твойто и виж къде какво е барнато.
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе