Pun U Association Wah Yan Primary School

SQL 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 'AND MONTH(news_dt) >= 9 ORDER BY 1 DESC' at line 1

SELECT DISTINCT(YEAR(news_dt)) AS distYr
FROM news
WHERE news_lang = 'tc' AND news_nc_id = AND MONTH(news_dt) >= 9
ORDER BY 1 DESC

SQL 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 'AND news_dt <= '2025-11-06' AND ( news_set_end = 'N' OR ( news_set_end = 'Y' ...' at line 1

SELECT *
FROM news
WHERE news_lang = 'tc' AND news_nc_id = AND news_dt <= '2025-11-06' AND ( news_set_end = 'N' OR ( news_set_end = 'Y' AND news_dt_end > '2025-11-06' ) ) AND news_show = 'Y'
ORDER BY news_dt DESC , news_sort_id
LIMIT 0 , 9

校友會

學校概覽

學與教

華小社群