";
$addcount = ($count + 1);
$sql = "UPDATE tblPicture SET count = $addcount WHERE ID = ".$_GET['id']." LIMIT 1";
$result = mysqli_query($db_connect_id,$sql);
if ($_SESSION['login'] != '1')
{
$_SESSION['failuremessage'] = "Du er ikke logget inn";
}else{
$_SESSION['failuremessage'] = '';
}
?>
$sql = "SELECT COUNT(*) picture_id FROM tblComment
WHERE tblComment.picture_id= ".$_GET['id']."";
$countresult = mysqli_query($db_connect_id,$sql);
// print the count result to your browser
$count = mysqli_result($countresult,0,0);
//print ($count);
$sql_string = "SELECT * FROM tblComment WHERE picture_id = ".$_GET['id']." order by date DESC, time DESC;";
$query_result = mysqli_query($db_connect_id,$sql_string);
if ($count != 0)
{
print "
';
//se etter nye i gjestebok
$sql = "SELECT COUNT(ID) FROM 2006_mailbox WHERE toPersonID = '".$_SESSION['userID']."' AND new = '1' AND active = '1' AND private = '0'";
$countresult = mysqli_query($db_connect_id,$sql);
$count = mysqli_result($countresult,0,0);
if ($count != 0)
{
if ($count == '1')
{
$new ='ny';
}else{
$new ='nye';
}
print ''.$count .' '.$new.' i gjestebok
';
}
//se etter nye i mailboks
$sql = "SELECT COUNT(ID) FROM 2006_mailbox WHERE toPersonID = '".$_SESSION['userID']."' AND new = '1' AND active = '1' AND private = '1'";
$countresult = mysqli_query($db_connect_id,$sql);
$count = mysqli_result($countresult,0,0);
if ($count != 0)
{
if ($count == '1')
{
$new ='nytt';
}else{
$new ='nye';
}
print ''.$count .' '.$new.' førjulsbrev