All pastes #952826 Raw Edit

Etwas

public text v1 · immutable
#952826 ·published 2008-03-22 15:45 UTC
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);


?>