modoer模板中执行sql语句

 模板中执行sql语句 直接查询数据库

<!--SELECT sid,aid,name,subname,avgsort,thumb,description FROM  modoer_subject WHERE finer>0 AND status=1  ORDER BY finer DESC LIMIT 0,10--> 

                         {get:modoer val=table(table/dbpre_subject/select/sid,aid,name,subname,avgsort,thumb,description/where/finer>0 AND status=1/orderby/finer DESC/rows/10/cachetime/1000)} 

                         <li> 

                             <div><a href="{url item/detail/id/$val[sid]}"><img src="{URLROOT}/{if $val[thumb]}$val[thumb]{else}static/images/noimg.gif{/if}" alt="$val[name].$val[subname]" title="$val[name].$val[subname]" /></a></div> 

                             <p><a href="{url item/detail/id/$val[sid]}" title="$val[name].$val[subname]">{sublen $val[name].$val[subname],10}</a></p> 

                         </li> 

                         {/get}