Форум PHP

Num должен быть 12
$num = 12;

Замените на это:

<?php include "3d_config.php"; $nameget=$_GET['folder']; $num = 5; $page = $_GET['page']; $result = mysql_query("select COUNT(*) from graphic where `folder` like '$nameget' ORDER BY `count` desc ;"); $posts = mysql_result($result, 0, 0); $total = intval(($posts - 1) / $num) + 1; $page = intval($page); if(empty($page) or $page < 0) $page = 1; if($page > $total) $page = $total; $start = $page * $num - $num; $result = mysql_query("SELECT * from graphic where `folder` like '$nameget' order by `count` desc LIMIT $start, $num;"); echo "<table width='100%' height='100% border='0' bordercolor=Dimgray bgcolor= '#080808' cellspacing='5' cellpadding='5'>"; $final = 0; while($postrow[] = mysql_fetch_array($result)) if($final == 0) echo "<tr>"; for($i = 0; $i < $num; $i++) { if( !isset( $postrow[$i] ) )break; echo '<td align="center" valign="bottom"><a href="'.'r_3d_id.php?id='.$postrow[$i]['id'].'" title="'.$postrow[$i]['link'].'" target="_blank"><IMG onmouseover=nereidFade(this,100,90,90) style="FILTER: alpha(opacity=80)" onmouseout=nereidFade(this,60,5,5) src="3d graphic/_thumb/'.$postrow[$i]['folder'].'/ '.$postrow[$i]['img'].'" alt="'.$postrow[$i]['title_rus'].'" ></a><br><b><a href="'.'r_3d_id.php?id='.$postrow[$i]['id'].'" title="'.$postrow[$i]['link'].'" target="_blank">3D '.$postrow[$i]['folder_rus'].'</b></a><br><font size="-2" face="Arial, Helvetica, sans-serif"> &#207;&#240;&#238;&#241;&#236;&#238;&#242;&#240;&#238;&#226; : '.$postrow[$i]['count'].'</font></td>'; $final++; if($final == 3) { echo "</tr>"; $final = 0; } } echo "</table>"; ?> <br> <?php $nameget=$_GET['folder']; if($page - 1 > 0) $page1left = '<a href= ./r_3d_group.php?folder='.$nameget.'&page='. ($page - 1) .'>&#207;&#240;&#229;&#228;&#251;&#228;&#243;&#249;&#224;&#255;</a> '; if($page + 1 <= $total) $page1right = '<a href= ./ r_3d_group.php?folder='.$nameget.'&page='. ($page + 1) .'>&#209;&#235;&#229;&#228;&#243;&#254;&#249;&#224;&#255;</a>'; echo '<table width="100%" border="0"> <tr> '; echo $pervpage.' <td align="center" valign="top" width="50%"><div id="nextprevious">'.$page2left.'&nbsp;'.$page1left.'</div></td> <td align="center" valign="top" width="50%"><div id="nextprevious">'.$page2right.'&nbsp;'.$page1right.'</div>'; echo '</td></tr></table>'; ?>

Ничего не изменилось

Замените это:

<?php if($page > $total) $page = $total; $start = $page * $num - $num; $result = mysql_query("SELECT * from graphic where `folder` like '$nameget' order by `count` desc LIMIT $start, $num;"); ?>

на:

<?php if($page > $total) $page = $total; $start = $page * $num - $num; $result = mysql_query("SELECT * from graphic where `folder` like '$nameget' order by `id` desc LIMIT $start, $num;"); ?>

http://fanatika.ru/r_3d_group.php?folder=Weapon&page=6

Показывает не существующие изображения как их убрать, никак не могу

Код!

<?php include "3d_config.php"; $nameget=$_GET['folder']; $num = 12; $page = $_GET['page']; $result = mysql_query("select COUNT(*) from graphic where `folder` like '$nameget' ORDER BY `count` desc ;"); $posts = mysql_result($result, 0, 0); $total = intval(($posts - 1) / $num) + 1; $page = intval($page); if(empty($page) or $page < 0) $page = 1; if($page > $total) $page = $total; $start = $page * $num - $num; $result = mysql_query("SELECT * from graphic where `folder` like '$nameget' order by `count` desc LIMIT $start, $num;"); echo "<table width='100%' height='100% border='0' bordercolor=Dimgray bgcolor= '#080808' cellspacing='5' cellpadding='5'>"; $final = 0; while($postrow[] = mysql_fetch_array($result)) if($final == 0) echo "<tr>"; for($i = 0; $i < $num; $i++) { if( !isset( $postrow[$i] ) )break; echo '<td align="center" valign="bottom"><a href="'.'r_3d_id.php?id='.$postrow[$i]['id'].'" title="'.$postrow[$i]['link'].'" target="_blank"><IMG onmouseover=nereidFade(this,100,90,90) style="FILTER: alpha(opacity=80)" onmouseout=nereidFade(this,60,5,5) src="3d graphic/_thumb/'.$postrow[$i]['folder'].'/'.$postrow[$i]['img'].'" alt="'.$postrow[$i]['title_rus'].'" ></a><br><b><a href="'.'r_3d_id.php?id='.$postrow[$i]['id'].'" title="'.$postrow[$i]['link'].'" target="_blank">3D '.$postrow[$i]['folder_rus'].'</b></a><br><font size="-2" face="Arial, Helvetica, sans-serif"> &#207;&#240;&#238;&#241;&#236;&#238;&#242;&#240;&#238;&#226; : '.$postrow[$i]['count'].'</font></td>'; $final++; if($final == 3) { echo "</tr>"; $final = 0; } } echo "</table>"; ?> <br> <?php $nameget=$_GET['folder']; if($page - 1 > 0) $page1left = '<a href= ./r_3d_group.php?folder='.$nameget.'&page='. ($page - 1) .'>&#207;&#240;&#229;&#228;&#251;&#228;&#243;&#249;&#224;&#255; </a> '; if($page + 1 <= $total) $page1right = '<a href= ./ r_3d_group.php?folder='.$nameget.'&page='. ($page + 1) .'>&#209;&#235;&#229;&#228;&#243;&#254;&#249;&#224;&#255;</a>'; echo '<table width="100%" border="0"> <tr> '; echo $pervpage.' <td align="center" valign="top" width="50%"><div id="nextprevious">'.$page2left.'&nbsp;'.$page1left. '</div></td> <td align="center" valign="top" width="50%"><div id="nextprevious">'.$page2right.'&nbsp;'.$page1right.'</div>'; echo '</td></tr></table>'; ?>