Missing global

[squirrelmail.git] / functions / abook_database.php

diff --git a/functions/abook_database.php b/functions/abook_database.php
index 532ef988b11aa52a1bff8af76dc08b1ed0b1e5a1..94a9180e7dcffe25d4f05e2624b93317c0981a00 100644 (file)
--- a/functions/abook_database.php
+++ b/functions/abook_database.php
@@ -173,8 +173,8 @@ class abook_database extends addressbook_backend {
             return false;
         }
          
-        $query = sprintf("SELECT * FROM %s WHERE owner='%s' AND nickname='%s'",
-                         $this->table, $this->owner, $alias);
+        $query = sprintf("SELECT * FROM %s WHERE owner='%s' AND LOWER(nickname)='%s'",
+                         $this->table, $this->owner, $this->dbh->quoteString($alias));
 
         $res = $this->dbh->query($query);