From e2da9b0bd63cfc64b3ca3316e5dd4404bfccfa4a Mon Sep 17 00:00:00 2001 From: icewing Date: Wed, 2 Apr 2008 11:22:18 +0000 Subject: Marcus Povey * Value to value_id git-svn-id: https://code.elgg.org/elgg/trunk@356 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/annotations.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/engine/lib/annotations.php b/engine/lib/annotations.php index 0a06b2afe..3f965ec6d 100644 --- a/engine/lib/annotations.php +++ b/engine/lib/annotations.php @@ -246,7 +246,7 @@ $where[] = "a.name_id='$name'"; if ($value != "") - $where[] = "a.value='$value'"; + $where[] = "a.value_id='$value'"; $query = "SELECT a.*, n.string as name, v.string as value from {$CONFIG->dbprefix}annotations a JOIN {$CONFIG->dbprefix}entities e on a.entity_guid = e.guid JOIN {$CONFIG->dbprefix}metastrings v on a.value_id=v.id JOIN {$CONFIG->dbprefix}metastrings n on a.name_id = n.id where "; foreach ($where as $w) -- cgit v1.2.3