hi, i have some problem when i want to post a news
i see here is `published` and need to be `displayed` and "AND `intern` = 0 " is removed
$db_news = safe_query(
"SELECT * FROM `" . PREFIX . "news` WHERE `published` = 1 AND `intern` = 0 ORDER BY `date` DESC LIMIT 0,10"
but i have an other error
How can i solve this?
- MySQL error no.: 1054
- MySQL error: Unknown column 'language' in 'where clause'
- SQL: SELECT * FROM `***_plugins_news` WHERE `newsID` = 5 AND `language` = 'en'
/home/******/public_html/******/admin/admincenter.php(243): include('/home/******/public_html/******/includes/plugins/news/admin/admin_news.php')
/home/******/public_html/******/includes/plugins/news/admin/admin_news.php(190): generate_rss2()
func/feeds.php(41): safe_query('SELECT
*
FROM
`***_plugins_news`
WHERE
`newsID` = 5 AND
`language` = \'en\'')