projects
/
phpfspot.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
fixed sql query for tag-search
[phpfspot.git]
/
phpfspot.class.php
diff --git
a/phpfspot.class.php
b/phpfspot.class.php
index c2ec3ac78e381c738b68a169cef3657463bf7f33..826fafd2d1101b792306590de0cd032731443a7d 100644
(file)
--- 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
FROM photo_tags pt1
INNER JOIN photo_tags pt2
ON pt1.photo_id=pt2.photo_id
- INNER JOIN tags t
1
- ON pt1.tag_id=t
1
.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
INNER JOIN photos p
ON pt1.photo_id=p.id
INNER JOIN tags t2
ON pt2.tag_id=t2.id
- WHERE t
1
.name LIKE '%". $_SESSION['searchfor'] ."%' ";
+ WHERE t.name LIKE '%". $_SESSION['searchfor'] ."%' ";
if(isset($additional_where_cond))
$query_str.= "AND ". $additional_where_cond ." ";
if(isset($additional_where_cond))
$query_str.= "AND ". $additional_where_cond ." ";