".$fotoID." order by fDate asc";
$nextFotoData = @mysql_query($selectNextFoto,$dbh);
$nextFoto = @mysql_result($nextFotoData, 0, 0);
// Select Next Random Photo
if ($random != "") {
$selectRandomFoto = "select fID, date_format(fDate, '%Y%m%d')
from bbPhoto
where ".$basic." order by rand()";
$randomFotoData = @mysql_query($selectRandomFoto,$dbh);
$randomFoto = @mysql_result($randomFotoData, 0, 1);
}
// Select Previous Photo
$selectPrevFoto = "select date_format(fDate, '%Y%m%d'), fID, frUserID
from bbPhoto
where ".$basic." and date_format(fDate, '%Y%m%d') < ".$fotoID." order by fDate desc";
$prevFotoData = @mysql_query($selectPrevFoto,$dbh);
$prevFoto = @mysql_result($prevFotoData, 0, 0);
// Select First Photo
$selectFirstFoto = "select date_format(fDate, '%Y%m%d'), fID, frUserID
from bbPhoto
where ".$basic."
order by fDate
asc";
$firstFotoData = @mysql_query($selectFirstFoto,$dbh);
$firstFoto = @mysql_result($firstFotoData, 0, 0);
// Load Comments
$select_comment = "select fID as CommentID, fName as Name, fWebsite as Website, fComment as Kommentar, frFotoID, date_format(fCreated, '%d.%m.%Y at %H:%i') as Datum, fCreated, frUserID
from bbGuestbook
where frFotoID = ".$photoID."
order by fCreated
desc";
$comment_data = @mysql_query($select_comment,$dbh);
$comment_check_data = @mysql_query($select_comment,$dbh);
$comment_check = @mysql_result($comment_check_data, 0, 0);
include("inc/nav.php");
?>
">
Variablentester: $_SERVER['SERVER_NAME']:
