News & Events
Severity: Notice
Message: Undefined index: row_no
Filename: helpers/article_helper.php
Line Number: 135
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by row_no desc limit 1' at line 5
select * from ( select a.*, c.cat_code, (@row_num:=@row_num+1) as row_no from en_article as a left join en_category as c on a.cat_id=c.cat_id, (select(@row_num:=0)) as b where a.is_show=1 and is_via=2 ORDER BY a.`art_sort` desc, a.`art_dateline` desc, a.`art_id` desc) as res where cat_id = '' and row_no < order by row_no desc limit 1
Filename: /var/www/web/pharm/en/helpers/article_helper.php
Line Number: 135