|
|
|
| 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">
Ïðîñìîòðîâ
: '.$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)
.'>Ïðåäûäóùàÿ
</a> ';
if($page + 1 <= $total) $page1right = '<a href= ./
r_3d_group.php?folder='.$nameget.'&page='. ($page + 1)
.'>Ñëåäóþùàÿ</a>';
echo '<table width="100%" border="0">
<tr>
';
echo $pervpage.'
<td align="center" valign="top" width="50%"><div
id="nextprevious">'.$page2left.' '.$page1left.
'</div></td>
<td align="center" valign="top" width="50%"><div id="nextprevious">'.$page2right.' '.$page1right.'</div>';
echo '</td></tr></table>';
?>
|
| |
|
|
|
|
|
|
|
для: Dibilan
(14.06.2008 в 15:52)
| | Замените это:
<?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;");
?>
|
| |
|
|
|
|
|
|
|
для: t3ma
(14.06.2008 в 16:07)
| | Ничего не изменилось | |
|
|
|
|
|
|
|
для: Dibilan
(14.06.2008 в 16:14)
| | Замените на это:
<?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">
Ïðîñìîòðîâ : '.$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)
.'>Ïðåäûäóùàÿ</a> ';
if($page + 1 <= $total) $page1right = '<a href= ./
r_3d_group.php?folder='.$nameget.'&page='. ($page + 1)
.'>Ñëåäóþùàÿ</a>';
echo '<table width="100%" border="0">
<tr>
';
echo $pervpage.'
<td align="center" valign="top" width="50%"><div id="nextprevious">'.$page2left.' '.$page1left.'</div></td>
<td align="center" valign="top" width="50%"><div id="nextprevious">'.$page2right.' '.$page1right.'</div>';
echo '</td></tr></table>';
?>
|
| |
|
|
|
|
|
|
|
для: t3ma
(14.06.2008 в 16:23)
| | Num должен быть 12
$num = 12; | |
|
|
|