".$fotoID." order by fo.fDate asc";
$nextFotoData = @mysql_query($selectNextFoto,$dbh);
$nextFoto = @mysql_result($nextFotoData, 0, 0);
// Select Next Random Photo
if ($random != "") {
$selectRandomFoto = "select fo.fID, date_format(fo.fDate, '%Y%m%d'), fows.frFotoID, fows.frWebsiteID
from tb_Foto fo
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic." order by rand()";
$randomFotoData = @mysql_query($selectRandomFoto,$dbh);
$randomFoto = @mysql_result($randomFotoData, 0, 1);
}
// Select Previous Photo
$selectPrevFoto = "select date_format(fo.fDate, '%Y%m%d'), fo.fID, fo.fPublic, fows.frFotoID, fows.frWebsiteID
from tb_Foto fo
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic." and date_format(fo.fDate, '%Y%m%d') < ".$fotoID." order by fo.fDate desc";
$prevFotoData = @mysql_query($selectPrevFoto,$dbh);
$prevFoto = @mysql_result($prevFotoData, 0, 0);
// Select First Photo
$selectFirstFoto = "select date_format(fo.fDate, '%Y%m%d'), fo.fID, fo.fPublic, fows.frFotoID, fows.frWebsiteID
from tb_Foto fo
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
order by fo.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
from comGuestbook
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: $basicUserID:
