[Comoblog-commit] comoblog/modules/mod_search/include blog_search.inc.php,1.2,1.3
Status: Inactive
Brought to you by:
markwallis
|
From: Mark W. \(a. serialmonkey\) <mar...@us...> - 2005-11-25 04:31:28
|
Update of /cvsroot/comoblog/comoblog/modules/mod_search/include In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9196/include Modified Files: blog_search.inc.php Log Message: 1361701 - Fixed site_url issues and search results after post deletion Index: blog_search.inc.php =================================================================== RCS file: /cvsroot/comoblog/comoblog/modules/mod_search/include/blog_search.inc.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- blog_search.inc.php 5 Oct 2005 01:38:32 -0000 1.2 +++ blog_search.inc.php 25 Nov 2005 04:31:16 -0000 1.3 @@ -6,8 +6,9 @@ $search_string = strtolower($search_string); $posts = array(); - $query = "select distinct post_id from ".CFG_MYSQL_TABPREFIX."blog_search_index - where word like '%".$search_string."%'"; + $query = "select distinct s.post_id from ".CFG_MYSQL_TABPREFIX."blog_search_index s, ".CFG_MYSQL_TABPREFIX."posts p + where s.word like '%".$search_string."%' + and s.post_id = p.post_id"; $res = mysql_query($query); |