query($query);
$row = $results->fetchArray();
echo "Reading the post with ID $myid...
\n";
if($row)
{
$title = $row['post_title'];
$content = $row['post_content'];
$user = $row['post_author'];
$date = $row['post_date'];
$url = $row['guid'];
echo "$title\n";
echo "by #$user Date: $date\n";
echo "
";
echo "$content
\n";
echo "
";
echo "SQLite Tutorial - Scriptol.com";
}
else
{
echo "Can't access $mytable table.";
}
?>