Parašė Pakartoti slaptažodį· 2011 Bal. 10 16:04:25
#2
<?php
$dv = mysql_query("SELECT * from dovanos ORDER BY laikas DESC LIMIT 0,5");
echo "<table cellpadding='0' cellspacing='1' width='95%' class='tbl-border' align='center'>
<tr><td class='tbl1' align='center'>Kas:</td><td class='tbl1' align='center'>Dovana:</td><td class='tbl1' align='center'>Kam:</td><td class='tbl1' align='center'>Laikas:</td></tr>";
while ($q = mysql_fetch_array($dv))
{
$kas = $q['kas'];
$dovana = $q['dovana'];
$laikas = $q['laikas'];
$kam = $q['kam'];
$us = mysql_query("SELECT user_name, user_avatar from ".DB_USERS." WHERE user_id='$kas'");
while ($q = mysql_fetch_array($us))
{
$user_name = $q['user_name'];
$user_avatar = $q['user_avatar'];
}
$uss = mysql_query("SELECT user_name, user_avatar from ".DB_USERS." WHERE user_id='$kam'");
while ($q = mysql_fetch_array($uss))
{
$user_namee = $q['user_name'];
$user_avatarr = $q['user_avatar'];
}
echo "<tr><td width='25%' class='tbl1' align='center'><a href='".BASEDIR."profile.php?lookup=$kas'>$user_name</a></td><td width='20%' class='tbl1' align='center'><img src='".IMAGES."dovanos/$dovana.png'></td><td width='25%' class='tbl1' align='center'><a href='".BASEDIR."profile.php?lookup=$kam'>$user_namee</a></td><td width='30%' class='tbl1' align='center'>";
echo date("Y-m-d, H:i:s", $laikas);
echo "</td></tr>";
}
echo "</table>";
?>
Redagavo Pakartoti slaptažodį· 2011 Bal. 10 16:04:04