zodiak, А как сделать чтоб было так
Имя темы
Ник последнего
Дата?
Panser (06.04.2010/17:18)
Please help me,, last upload, date, month, year, inappropriate, 01/01/1970. Please show where the error
echo '<div class="bmenu">Last 5 Upload</div>';
$old = $realtime - (3 * 24 * 3600);
$newfile = mysql_query("SELECT * FROM `download` WHERE `time` > '" . $old . "' AND `type`='2' AND `avtor` != 'noviewthis' ORDER BY `time` DESC LIMIT 5");
if (mysql_num_rows($newfile)){
while ($newf = mysql_fetch_array($newfile))
{
$filtime = date("d.m.Y", $newf['time']);
echo '<div class="menu">';
echo "$newf[name]<br />";
echo "<b>Uploaded: </b>$filtime |<a href='download/?act=view&file=" . $newf['id'] . "'> Details</a><br />";
echo '</div>';
}
}else{
echo '<div class="menu">No new file </div>';
}
echo "<form action='download/?act=search' method='post'>";
echo '<div class="bmenu">Cari file:</div>';
echo "<div class='menu'><input type='text' name='srh' size='26' maxlength='26' title='masukan query pencarian' value=''/><br />";
echo "<input type='submit' title='klik cari file untuk mencari' value='Cari file'/></div></form>";
seg0ro (06.04.2010/17:44)This worked perfectly, thanks mr.segOro
[php]echo '<div class="bmenu">Last 5 Upload</div>';$old = $realtime - (3 * 24 * 3600);$newfile = mysql_query("SELECT * FROM `download` WHERE `time` > '" . $old . "' AND `type`='2' AND `avtor` != 'novi
seg0ro (06.04.2010/17:44)mr.seg0ro,, how to display images on file gif, png, jpg, etc. ?
[php]echo '<div class="bmenu">Last 5 Upload</div>';$old = $realtime - (3 * 24 * 3600);$newfile = mysql_query("SELECT * FROM `download` WHERE `time` > '" . $old . "' AND `type`='2' AND `avtor` != 'novi