summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--getjson.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/getjson.php b/getjson.php
index 14af09b..007ef7c 100644
--- 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 ".
- " 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 ".
- " where tags.name in ($tags)");
+ " where tags.name COLLATE NOCASE in ($tags)");
}
else