---------SQL-------------------------------------------
update scu.NEWS set views=views +1 where id=?lang=en
---------ERROR-----------------------------------------
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?lang=en' at line 1
---------SQL-------------------------------------------
select en_subject as subject,en_message as message,en_place as place,sort,enable,id,views,image,dates,time,categoryId,startDate from scu.NEWS as tb where tb.enable=1 and tb.id=?lang=en
---------ERROR-----------------------------------------
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?lang=en' at line 1
---------SQL-------------------------------------------
select en_subject as subject,image,id,views from scu.NEWS as tb where tb.enable=1 and tb.startDate < NOW() and (tb.endDate > NOW() or tb.endDate is null or tb.endDate ='0000-00-00 00:00:00') and tb.categoryId= order by views desc limit 4
---------ERROR-----------------------------------------
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by views desc limit 4' at line 1
東吳人權教育網

Most Views