<?php
$Config = new JConfig();
$dbtype = $Config->dbtype;
$host = $Config->host;
$user = $Config->user;
$pass = $Config->password;
$dbname = $Config->db;
$prefix = $Config->dbprefix;
$conn = new mysqli($host, $user, $pass, $dbname);
if($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }
$sql = "SELECT id, title FROM jo254_content order by id";
$result = $conn->query($sql);
echo "<table>";
foreach($result as $row) {
echo "<tr style=\"border-bottom: solid 1px #000\"><td width=\"50px\">" . $row['id'] . "</td><td>" . $row['title'] . "</td><td><a href='mailto:" . $row['id'] . "'>" . $row['title'] . "</a></td></tr>";
}
echo "</table>";
$conn->close();
?>