From 499ed21564a6709891ccbd9565a299b6b2b8c401 Mon Sep 17 00:00:00 2001 From: moodler Date: Thu, 13 Apr 2006 08:49:31 +0000 Subject: [PATCH] FIxed a typo --- mod/data/view.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/mod/data/view.php b/mod/data/view.php index 8034e0d6d2..6fee9af046 100755 --- a/mod/data/view.php +++ b/mod/data/view.php @@ -306,7 +306,7 @@ AND r.dataid = '.$data->id.' AND r.userid = u.id AND c1.recordid = r.id '; - $sortorder = ' ORDER BY '.$sortcontentfull.' '.$order.' , r.id ASC'; + $sortorder = ' ORDER BY '.$sortcontentfull.' '.$order.' , r.id ASC '; if ($search) { $searchselect = ' AND (c1.content LIKE "%'.$search.'%") '; } else { @@ -320,7 +320,7 @@ $where = 'WHERE c.recordid = r.id AND r.userid = u.id AND r.dataid = '.$data->id; - $sortorder = ' ORDER BY r.id ASC'; + $sortorder = ' ORDER BY r.id ASC '; $searchselect = ' AND (c.content LIKE "%'.$search.'%") '; } else { @@ -369,6 +369,7 @@ # $sqlindex = 'SELECT COUNT(DISTINCT c.recordid) '.$fromsql.$lessthan.$sortorder; # $page = count_records_sql($sqlindex); + $allrecords = get_records_sql($sqlselect); // Kludgey but accurate at least! $page = 0; foreach ($allrecords as $key => $allrecord) { -- 2.39.5