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