aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoricewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-04-02 11:22:18 +0000
committericewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-04-02 11:22:18 +0000
commite2da9b0bd63cfc64b3ca3316e5dd4404bfccfa4a (patch)
tree62d2a3942654fcc45e1f4cb0bb24b0b243ee39d6
parenta7dcde114d01d22d205995a52e276385e29f332f (diff)
downloadelgg-e2da9b0bd63cfc64b3ca3316e5dd4404bfccfa4a.tar.gz
elgg-e2da9b0bd63cfc64b3ca3316e5dd4404bfccfa4a.tar.bz2
Marcus Povey <marcus@dushka.co.uk>
* Value to value_id git-svn-id: https://code.elgg.org/elgg/trunk@356 36083f99-b078-4883-b0ff-0f9b5a30f544
-rw-r--r--engine/lib/annotations.php2
1 files changed, 1 insertions, 1 deletions
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)