From 93ac7cb91db74b6043f0aeb54a548f9a5560a15e Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Mon, 28 Feb 2005 19:34:11 +0000
Subject: fixed bug #2285 needed a has_where clause before the LocationID
 parameter to the query builder

---
 web/lib/pkgfuncs.inc | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'web')

diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 4c21702..0b451ce 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -488,7 +488,11 @@ function pkg_search_page($SID="") {
 	$has_where = 1;
 
 	if (intval($_REQUEST["L"])) {
-		$q.= "WHERE LocationID = ".intval($_REQUEST["L"])." ";
+		if (!$has_where) {
+		  $q.= "WHERE LocationID = ".intval($_REQUEST["L"])." ";
+		} else {
+			$q .= "AND LocationID = ".intval($_REQUEST["L"])." ";
+		}
 		$has_where = 1;
 	}
 	if (intval($_REQUEST["C"])) {
-- 
cgit v1.2.3-70-g09d2