diff options
| author | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-04-02 11:22:18 +0000 |
|---|---|---|
| committer | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-04-02 11:22:18 +0000 |
| commit | e2da9b0bd63cfc64b3ca3316e5dd4404bfccfa4a (patch) | |
| tree | 62d2a3942654fcc45e1f4cb0bb24b0b243ee39d6 | |
| parent | a7dcde114d01d22d205995a52e276385e29f332f (diff) | |
| download | elgg-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.php | 2 |
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) |