From 231dd799e9fefdac3328ee2ee4e64fb2889e03cc Mon Sep 17 00:00:00 2001 From: icewing Date: Tue, 18 Mar 2008 10:53:58 +0000 Subject: Marcus Povey * Moved order and limit the right way git-svn-id: https://code.elgg.org/elgg/trunk@245 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/metadata.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'engine/lib') 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"); } -- cgit v1.2.3