<?php
$id = isset($_GET['id']) ? $_GET['id'] : NULL;
$op = mysql_query("SELECT * FROM `picks` WHERE id = '$id'") or die (mysql_error());
$check = mysql_num_rows($op);
$rdy = mysql_fetch_array($op);
if ($check > 0)
{
$id = $rdy['id'];
$back_s = mysql_query("SELECT * FROM `picks` WHERE `id` > '$id' GROUP BY `id` ORDER BY `id` ASC LIMIT 1") or die(mysql_error());
$back_n = mysql_num_rows($back_s);
if ($back_n > 0)
{
$back_r = mysql_fetch_array($back_s);
$b_id = $back_r['id'];
$prevpage = "<a href='?id=$b_id'><img src='http://victory-bg.info/img/prev.png' title='Предишно изожражение' border='0' /></a>";
}
else
{
$prevpage = "<img src='http://victory-bg.info/img/prev_h.png' title='Няма изображения назад' border='0' />";
}
$next_s = mysql_query("SELECT * FROM `picks` WHERE `id` < '$id' GROUP BY `id` ORDER BY `id` DESC LIMIT 1") or die(mysql_error());
$next_n = mysql_num_rows($next_s);
if ($next_n > 0)
{
$next_r = mysql_fetch_array($next_s);
$n_id = $next_r['id'];
$nextpage = "<a href='?id=$n_id'><img src='http://victory-bg.info/img/next.png' title='Следващо изображение' border='0' /></a>";
}
else
{
$nextpage = "<img src='http://victory-bg.info/img/next_h.png' title='Няма изображения напред' border='0' />";
}
list($width, $height) = getimagesize("upload/$rdy[image]");
$max_width = "300"; // максимална широчина
$max_height = "200"; // максимална височина
if ($width > $max_width) { $new_width = $max_width; }
else { $new_width = $width; }
if ($height > $max_height) { $new_height = $max_height; }
else { $new_height = $height; }
echo "<img src='http://www.victory-bg.info/upload/$rdy[image]' width='$new_width' height='$new_height' /><br />";
echo "<center>$prevpage $nextpage</center><br />";
}
else {
echo "Това изображение не съществува";
}
?>