diff options
| author | pjmattal <pjmattal> | 2005-02-28 19:34:11 +0000 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2005-02-28 19:34:11 +0000 |
| commit | 93ac7cb91db74b6043f0aeb54a548f9a5560a15e (patch) | |
| tree | a4b0eb5ae007f48cc5dfc701de73d18791204888 | |
| parent | ac7e555b3416ecad62a37f8ffa98e7e8bbcf6c3d (diff) | |
| download | aurweb-93ac7cb91db74b6043f0aeb54a548f9a5560a15e.tar.xz | |
fixed bug #2285
needed a has_where clause before the LocationID parameter to the query builder
| -rw-r--r-- | web/lib/pkgfuncs.inc | 6 |
1 files changed, 5 insertions, 1 deletions
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"])) { |