opentable(' Most Photocomments');







$sql = dbquery("SELECT * FROM ".$db_prefix."comments 

                   LEFT JOIN ".$db_prefix."photos ON photo_id=comment_item_id 

         WHERE comment_type='P' ORDER BY comment_datestamp DESC LIMIT 1");









  //Letzten Foto Kommentare

 // $sql = dbquery("SELECT * FROM ".$db_prefix."comments WHERE comment_type='P' ORDER BY comment_datestamp DESC LIMIT 1");

  if(dbrows($sql))

  {

    while($data = dbarray($sql))

    {





echo'



<div style="height:158px;">



<center>

<a border= "0" href="'.BASEDIR.'photogallery.php?photo_id='.$data['comment_item_id'].'" title="'.$data['comment_message'].'">

<img src="'.IMAGES.'photoalbum/album_'.$data['album_id'].'/'.$data['photo_thumb1'].'"></a><br>

'.parseubb(parsesmileys(trimlink($data['comment_message'], 25))).'



</div>

</center>';

  

  }

  }

  else

  {

    echo '<center>Keine Alben vorhanden</center>';

  }



closetable();