aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--engine/lib/metadata.php6
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");
}