Parašė Gedi Minas· 2007 Spa. 7 12:10:19
#2
opentable('Atsitiktinės dienos nuotraukos');
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 5"
);
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>";
closetable();
Va, šitaip.
;)
Redagavo Gedi Minas· 2007 Spa. 7 12:10:37