問題:
如何通過Mysql萬能標(biāo)簽,只調(diào)用PHP168系統(tǒng)已審核的商家新聞呢?
沒有通過審核的商家新聞也調(diào)用出來了,如何只調(diào)用已審核的商家新聞呢?
現(xiàn)在的Mysql語句為:
SELECT * FROM p8_business_homepage_article WHERE 1 order by posttime DESC LIMIT 3
回答:
用以下代碼即可實(shí)現(xiàn):
SELECT * FROM p8_business_homepage_article WHERE yz=1 order by posttime DESC LIMIT 3