Question

phpcms listinfo 怎么实现联表查询

Answer 1

1 自定义字段如果不是在主表中，如果要查询该字段，就要用到moreinfo="1" 实现该模型主表和附表关联查询.
例如：
{pc:content action="lists" catid="$catid" moreinfo="1" order="listorder DESC" num="10" }
{loop $data $val}
{$val['zidingyiziduan']}
如果没有moreinfo="1"就查询不到 {$val['zidingyiziduan']}
2 另外就只能写sql关联查询了！
{pc:get sql="select a.`url`,a.`catid`,a.`title`,a.`description` from v9_news as a left join v9_position_data as b on a.id = b.id and a.catid=b.catid where a.catid= 6 and a.status =99 and b.posid = 11 group by a.id order by a.id desc" num="10" start="0"}
{loop $data $r}