query($query);
$row = $results->fetchArray();
echo "Searching posts with the keyword '$word' inside... \n";
if($results)
{
$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 "And the identifier is ", $row['ID'], " which we will use to change the post.\n";
echo "
";
echo "SQLite Tutorial - Scriptol.com";
}
else
{
echo "Can't access $mytable table.";
}
?>