extend nestedsets with fulltext query

From: Date: Sun, 30 Jan 2005 17:10:26 +0000
Subject: extend nestedsets with fulltext query
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-17275@lists.php.net to get a copy of this message
Hi all Is there a way to do a fulltext search with db nestedsets class? Something like : $addSQL = array(
              'WHERE MATCH' => 'name, content',
              'AGAINST' => 'willkommen'
              );
$search = $NSsmarty->getAllNodes(true, true, $addSQL); Without the nestedsets class its working: $search_query = "SELECT name,
                                         id,
                                         content,
                                         link
                         FROM nestedset
                         WHERE MATCH content,
                                                      name
                         AGAINST ('willkommen')
                ";
-->    http://dev.mysql.com/doc/mysql/en/fulltext-search.html
Regards roman

« previous php.pear.general (#17275) next »