DEDECMS官方发布的问答模块标签,只适合5.5,5.6升级后发现之前的标签全部不能用了,所以干脆写成sql调用了!下面就是标签:
我用单独的table做演示:
<table width="390" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td>{dede:sql sql="select dede_ask.id,dede_ask.title,dede_askanswer.content from dede_ask LEFT JOIN dede_askanswer on dede_ask.id=dede_askanswer.askid where dede_askanswer.ifanswer=1 and dede_askanswer.ifcheck=1 and dede_ask.bestanswer=dede_askanswer.id order by dede_ask.id desc LIMIT 0,3"} <table width="390" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="21"><a href="/ask/question.php?id=[field:id/]">问:[field:title function=cn_substr(@me,52)/]</a></td> </tr> </table> <table width="390" border="0" cellspacing="0" cellpadding="0"> <tr>
在泪水中浸泡过的微笑最灿烂,从迷惘中走出来的灵魂最清醒。