Parašė ramon· 2008 Rugp. 17 00:08:29
#6
Sioks toks papildimas:
$a = "SELECT * FROM ".DB_PREFIX."comments WHERE comment_type='P' OR comment_type='N' OR comment_type='A' ORDER BY comment_datestamp DESC LIMIT 5";
$b = dbquery($a);
while ($db = dbarray($b)) {
echo "<b>Data:</b> ".showdate("longdate", $db['comment_datestamp'])." <Br><b>Komentaras:</b> ".$db['comment_message']."<hr>";
}
Dar vienas papildimas, cia rodo is kokios kategorijos komentaras [naujienos, straipsniai arba nuotraukos] :
$a = "SELECT * FROM ".DB_PREFIX."comments WHERE comment_type='P' OR comment_type='N' OR comment_type='A' ORDER BY comment_datestamp DESC LIMIT 5";
$b = dbquery($a);
while ($db = dbarray($b)) {
if($db['comment_type'] == "P") { $kat = "Nuotraukos"; }
elseif($db['comment_type'] == "N") { $kat = "Naujienos"; }
elseif($db['comment_type'] == "A") { $kat = "Straipsniai"; }
echo "<b>Kategorija:</b> $kat<br> <b>Data:</b> ".showdate("longdate", $db['comment_datestamp'])." <Br><b>Komentaras:</b> ".$db['comment_message']."<hr>";
}
Redagavo ramon· 2008 Rugp. 17 01:08:49