1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
<?php
// Cache-busting: this page is loaded inside an iframe and refreshed via
// META refresh + the scheduled task updates the DB every minute. Without
// these headers browsers can heuristic-cache the iframe and show stale
// tracks for hours.
header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0');
header('Pragma: no-cache');
header('Expires: 0');
?>
<html>
<head>
<link href="../style/style.css" rel="stylesheet" type="text/css">
<META HTTP-EQUIV="refresh" CONTENT="50">
</head>
<body bgcolor="#171717">
<?php
require_once("../admin/dbconn.php");
$la = mysql_query("SELECT * FROM lastfive ORDER BY date DESC LIMIT 4");
echo '<table cellpadding="5" cellspacing="0" border="0" summary="" style="padding:5px;" align="center">';
$i = "1";
while($myrow = mysql_fetch_array($la)){
echo '<tr>
<td><span class="title5">'.$i.'</span></td>
<td><img src="images/icon.gif" alt=""></td>
<td class="tit5"><span class="title5">'.substr($myrow['0'], 0, 20).'</span><span class="author5"><br>'.substr($myrow['1'], 0, 20).'</span></td>
</tr>';
$i++;
}
echo '</table>';
?>
</body>
</html>
|