rendered paste body<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("prebot", $con);
$result = mysql_query("SELECT * FROM predb WHERE ctime LIMIT 25");
echo mysql_error();
echo "<table border='1'>
<tr>
<th>id</th>
<th>status</th>
<th>ctime</th>
<th>Section</th>
<th>Releases</th>
<th>Group</th>
<th>size</th>
<th>files</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['status'] . "</td>";
$ctime = $row["ctime"];
$datetime = date("Y-m-d H:i:s", $ctime);
echo "$datetime";
echo "<td>" . $row['section'] . "</td>";
echo "<td>" . $row['rlsname'] . "</td>";
echo "<td>" . $row['grp'] . "</td>";
echo "<td>" . $row['size'] . "</td>";
echo "<td>" . $row['files'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>