From 93ac7cb91db74b6043f0aeb54a548f9a5560a15e Mon Sep 17 00:00:00 2001 From: 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