From 735d8bb81f8886927385d4b00d3bccea890594a6 Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Wed, 1 May 2024 12:23:36 +0300 Subject: [PATCH] space between operators --- erp24/modul/bonus/bonus_users.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erp24/modul/bonus/bonus_users.php b/erp24/modul/bonus/bonus_users.php index a42044d5..4bcd4a71 100644 --- a/erp24/modul/bonus/bonus_users.php +++ b/erp24/modul/bonus/bonus_users.php @@ -83,7 +83,7 @@ $limit = 100; $offset = !empty($_GET['p'])?(($_GET['p']-1)*$limit):0; $offset=(int)$offset; -$where .="order by $sort_by $asc_desc"; +$where .= " order by $sort_by $asc_desc"; echo $where; $sql = "SELECT *,TO_CHAR(bdate,'DD.MM.YYYY') as bdate2, TO_CHAR(date,'DD.MM.YYYY HH:MM') as date2 FROM users WHERE 1=1 $where LIMIT $limit OFFSET $offset"; $data = $db::getRows($sql, $binding); -- 2.39.5