arrayQuery($query, SQLITE_ASSOC);
$size = count($results);
echo "$size records in database
\n";
echo "\n";
echo "\n";
echo "| Title | ";
echo "Author | ";
echo "Date | ";
echo "Content | ";
echo "
\n";
for($i = 0; i < $size; $i++)
{
$arr = $results[$i];
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
";
?>