diff options
| author | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-18 10:53:58 +0000 |
|---|---|---|
| committer | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-18 10:53:58 +0000 |
| commit | 231dd799e9fefdac3328ee2ee4e64fb2889e03cc (patch) | |
| tree | e7974e3ec2e0667ca06a48f30ad861585599adee | |
| parent | 83d27eab014164d5988e6b16eaf5822f73218abb (diff) | |
| download | elgg-231dd799e9fefdac3328ee2ee4e64fb2889e03cc.tar.gz elgg-231dd799e9fefdac3328ee2ee4e64fb2889e03cc.tar.bz2 | |
Marcus Povey <marcus@dushka.co.uk>
* Moved order and limit the right way
git-svn-id: https://code.elgg.org/elgg/trunk@245 36083f99-b078-4883-b0ff-0f9b5a30f544
| -rw-r--r-- | engine/lib/metadata.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/engine/lib/metadata.php b/engine/lib/metadata.php index 6ef104dbb..3d5eb7c35 100644 --- a/engine/lib/metadata.php +++ b/engine/lib/metadata.php @@ -310,14 +310,14 @@ if ($meta_name!="") $where[] = "m.name='$meta_name'"; if ($meta_value!="") - $where[] = "m.value='$meta_value'"; + $where[] = "m.value_id='$meta_value'"; $query = "SELECT * from {$CONFIG->dbprefix}entities e JOIN {$CONFIG->dbprefix}metadata m on e.guid = m.entity_guid where"; foreach ($where as $w) $query .= " $w and "; $query .= " (e.access_id in {$access} or (e.access_id = 0 and e.owner_guid = {$_SESSION['id']}))"; // Add access controls - $query .= " order by $order_by limit $offset,$limit"; // Add order and limit - + $query .= " order by $order_by limit $limit, $offset"; // Add order and limit + echo $query; return get_data($query, "entity_row_to_elggstar"); } |