phpcms里执行一句SQL语句,请问正式格式是什么?

2025-04-13 09:18:18
推荐回答(1个)
回答1:

文章范围为59 60 61三个栏目,并且推送到了27 和28两个推荐位;
从第三条开始,连续调用7篇文章。
{pc:get sql="SELECT * FROM v9_news WHERE id IN (SELECT id FROM v9_position_data WHERE posid in(27,28) and catid in(59,60,61)) order by listorder DESC" cache="3600" start="3" num="7" return="data" }
{loop $data $n $r}

  • ·{str_cut($r[title],22,'')}

  • {/loop}
    {/pc}