From 8e84993bf96a7a53b56fa5c2b791a023f2877fb0 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 6 Jan 2006 14:14:19 +0100 Subject: [PATCH] fix search query (closes #30) --- backend.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/backend.php b/backend.php index e0141d7c..2dba06ef 100644 --- a/backend.php +++ b/backend.php @@ -1114,8 +1114,8 @@ $search_mode = db_escape_string($_GET["smode"]); if ($search) { - $search_query_part = "(upper(title) LIKE upper('%$search%') - OR content LIKE '%$search%') AND"; + $search_query_part = "(upper(ttrss_entries.title) LIKE upper('%$search%') + OR ttrss_entries.content LIKE '%$search%') AND"; } else { $search_query_part = ""; } @@ -1147,7 +1147,7 @@ // override query strategy and enable feed display when searching globally if ($search && $search_mode == "All feeds") { - $query_strategy_part = "id > 0"; + $query_strategy_part = "ttrss_entries.id > 0"; $vfeed_query_part = "ttrss_feeds.title AS feed_title,"; } else if (sprintf("%d", $feed) == 0) { $query_strategy_part = "ttrss_entries.id > 0"; -- 2.39.5