---

openside('Dienos nuotrauka');

echo "<div style='text-align:center'><table align='center'><tr>";

$result = dbquery(
"SELECT t1.photo_id, t1.album_id, t1.photo_title, t1.user_id, t2.user_name FROM ".$db_prefix."photos t1
LEFT JOIN ".$db_prefix."users t2 ON t1.user_id=t2.user_id ORDER BY photo_date DESC LIMIT 1"
);

if (dbrows($result) != 0 ) {
while($data = dbarray($result)) {
$filename = PHOTOS.$data['photo_id'].'t.jpg';
if (!file_exists($filename)) $filename = $image_url.'/imagenotfound.jpg';
echo "<td>
<a href='".BASEDIR."photogallery.php?photo=".$data['photo_id']."' class='gallery'><img src='".PHOTOS."".$data['photo_id']."t.jpg' width='".$settings['thumb_image_w']."' height='".$settings['thumb_image_h']."' title='".$data['photo_title']."' alt='".$data['photo_title']."'></a>
</td>";
}
}

echo"</tr></table></div>";
closeside();


Gal kas galėtų šį kodą kiek paredaguot, kad kasdien rodytų vis kitą nuotrauką?