if ($pic_nr == "") {
$sql = "SELECT picture_thumb FROM pictures ORDER BY id LIMIT 1 ";
} else {
$sql = "SELECT picture_thumb FROM pictures WHERE id='$pic_nr'";
}
$result = mysql_query($sql, $link);
if ($line = mysql_fetch_array($result))
{
$image = $line[0];
$size = getimagesize($local_pic_dir.$image);
if ($size) {
$size = $size[3];
}
//echo '
';
echo "
";
}
}
function get_cnt()
{
global $link;
$sql = "SELECT count(*) FROM pictures";
$result = mysql_query($sql, $link);
$line = mysql_fetch_array($result);
return $line[0];
}
function print_back($pic_nr)
{
$pic_nr = mysql_escape_string($pic_nr);
global $link;
if ($pic_nr == "") {
return "ZURÜCK";
} else {
$sql = "SELECT MAX(id) FROM pictures WHERE id < $pic_nr;";
}
$result = mysql_query($sql, $link);
$line = mysql_fetch_array($result);
if ($line[0]!=0) {
return "ZURÜCK";
} else {
return "ZURÜCK";
}
}
function print_next($pic_nr)
{
$pic_nr = mysql_escape_string($pic_nr);
global $link;
if ($pic_nr == "") {
$sql = "SELECT MIN(id) FROM pictures";
$result = mysql_query($sql, $link);
$line = mysql_fetch_array($result);
$id = $line[0];
$sql = "SELECT MIN(id) FROM pictures WHERE id > $id;";
} else {
$sql = "SELECT MIN(id) FROM pictures WHERE id > $pic_nr;";
}
$result = mysql_query($sql, $link);
$line = mysql_fetch_array($result);
if ($line[0]!=0) {
return "WEITER";
} else {
return "WEITER";
}
}
?>
$date_summerend)
{
$link_1 = '?preis=winter';
}
else
{
$link_1 = '?preis=sommer';
}
?>