Mine

<?php
$file = "blog.db";
$db = new SQLiteDatabase($file) or die("Not able to open database");
$query = "SELECT * FROM posts";
$result = $db->query($query) or die("Error in query");

if ($result->numRows() > 0) {
	echo "<table cellpadding=10 border=1>";
	while($row = $result->fetch()) {
		print '<div class="item"><h4><a href="?p=blog&amp;post='.$row[0].'">'.$row[1].'</a></h4><p>'.$row[2].'</p><p style="font-size:80%">'.$row[3].'</p></div><br class="c1" />';
	}
}
unset($db);
?>