From c13392b861fe83c2e28dd7804cfba563fcc61b3c Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Mon, 10 Dec 2007 09:12:59 +0000 Subject: tiny little tweak, came to me right before I headed off to bed, makes the sql query a tiny bit shorter when not doing basic sorts --- lib/class/browse.class.php | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'lib/class/browse.class.php') diff --git a/lib/class/browse.class.php b/lib/class/browse.class.php index 61baebcf..2767b749 100644 --- a/lib/class/browse.class.php +++ b/lib/class/browse.class.php @@ -679,11 +679,15 @@ class Browse { // If there's nothing there don't do anything if (!count($objects)) { return false; } + $where_sql .= "`id` IN ("; + foreach ($objects as $object_id) { $object_id = Dba::escape($object_id); - $where_sql .= "`id`='$object_id' OR"; + $where_sql .= "'$object_id',"; } - $where_sql = rtrim($where_sql,'OR'); + $where_sql = rtrim($where_sql,','); + + $where_sql .= ")"; $sql = self::get_base_sql() . ' WHERE ' . $where_sql; } -- cgit