From 757e336f0ac6fc2c636706343d4c63aff2f228e6 Mon Sep 17 00:00:00 2001 From: Andreas Unterkircher Date: Sat, 12 Jan 2008 13:06:53 +0100 Subject: [PATCH] fixed sql query for tag-search Signed-off-by: Andreas Unterkircher --- phpfspot.class.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/phpfspot.class.php b/phpfspot.class.php index c2ec3ac..826fafd 100644 --- a/phpfspot.class.php +++ b/phpfspot.class.php @@ -752,13 +752,13 @@ class PHPFSPOT { FROM photo_tags pt1 INNER JOIN photo_tags pt2 ON pt1.photo_id=pt2.photo_id - INNER JOIN tags t1 - ON pt1.tag_id=t1.id + INNER JOIN tags t + ON pt1.tag_id=t.id INNER JOIN photos p ON pt1.photo_id=p.id INNER JOIN tags t2 ON pt2.tag_id=t2.id - WHERE t1.name LIKE '%". $_SESSION['searchfor'] ."%' "; + WHERE t.name LIKE '%". $_SESSION['searchfor'] ."%' "; if(isset($additional_where_cond)) $query_str.= "AND ". $additional_where_cond ." "; -- 2.25.1