make tag search case insensitive

diff --git a/getjson.php b/getjson.php
index 14af09b3003bf7feb5f81a728e52b56f72228d79..007ef7c7d181c9f816d57eb2bcc5ab652aee3c9b 100644 (file)
--- a/getjson.php
+++ b/getjson.php
@@ -42,12 +42,12 @@ else
        $result = $DB->query("SELECT base_uri, filename FROM photos ".
                             "    left join photo_tags on photos.id=photo_tags.photo_id ".
                             "    left join tags on tags.id=photo_tags.tag_id ".
        $result = $DB->query("SELECT base_uri, filename FROM photos ".
                             "    left join photo_tags on photos.id=photo_tags.photo_id ".
                             "    left join tags on tags.id=photo_tags.tag_id ".

-                            "    where tags.name in ($tags) LIMIT $OFFSET, $N");
+                            "    where tags.name COLLATE NOCASE in ($tags) LIMIT $OFFSET, $N");

 
        $count = $DB->query("SELECT count(*) as total FROM photos ".
                            "    left join photo_tags on photos.id=photo_tags.photo_id ".
                            "    left join tags on tags.id=photo_tags.tag_id ".
 
        $count = $DB->query("SELECT count(*) as total FROM photos ".
                            "    left join photo_tags on photos.id=photo_tags.photo_id ".
                            "    left join tags on tags.id=photo_tags.tag_id ".

-                           "    where tags.name in ($tags)");
+                           "    where tags.name COLLATE NOCASE in ($tags)");

 
       }
     else
 
       }
     else