query($query);
echo "$size records in database
\n";
echo "\n";
echo "\n";
echo "| Title | ";
echo "Author | ";
echo "Date | ";
echo "Content | ";
echo "
\n";
while($arr = $results->fetchArray())
{
if(count($arr) == 0) break;
echo "\n";
$title = $arr['post_title'];
$content = $arr['post_content'];
$user = $arr['post_author'];
$date = $arr['post_date'];
$url = $arr['guid'];
echo "| $title | \n";
echo "#$user | ";
echo "$date | \n";
echo "$content | \n";
echo "
\n";
}
echo "
\n";
echo "
No more data...";
echo "
";
echo "SQLite Tutorial - Scriptol.com";
?>