$context['sim']) { $context = array('sim'=>$sim, 'title'=>$string); } } function most_similar_finalize(&$context) { return $context['title']; } chdir(dirname(__FILE__)); $db = new sqlite_db("./db2.sqlite"); /* * sqlite function name * PHP logic function * PHP finalize function * number of arguments not counting the context (optional) */ $db->create_aggregate('similar_text', 'most_similar', 'most_similar_finalize', 2); $title = 'mesg #2'; echo "Most Similar title to '{$title}' according to similar_text() is: "; echo $db->single_query("SELECT similar_text(title, '{$title}') FROM messages"); echo "
\n"; ?>