From 7d8b71f32de8ec781aff4641a9904a10e59828ff Mon Sep 17 00:00:00 2001 From: Andreas Unterkircher Date: Sun, 6 Jan 2008 17:52:37 +0100 Subject: [PATCH 1/1] used AND to add a show_tag constrait, but in case there hasn't been issued a WHERE query already a WHERE needs to be used instead of the AND Signed-off-by: Arun Persaud Signed-off-by: Andreas Unterkircher --- phpfspot.class.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/phpfspot.class.php b/phpfspot.class.php index cbb6fed..03fe9d4 100644 --- a/phpfspot.class.php +++ b/phpfspot.class.php @@ -877,7 +877,10 @@ class PHPFSPOT { $query_str.= "WHERE ". $additional_where_cond ." "; if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) { - $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')"; + if(isset($additional_where_cond)) + $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')"; + else + $query_str.= "WHERE t.name IN ('".implode("','",$this->cfg->show_tags). "')"; } if(isset($order_str)) -- 2.25.1