竞博jbo首页

DEDECMS SQL statement calls the title and URL of all sub columns under the specified column.

Author: royal network date: 2019-11-20 20:36 source: second

The DEDECMS SQL statement calls the title and URL of all sub columns under the specified column.


{dede:sql sql= "SELECT typename, typedir, ainiukeji, com FROM dede_" Arctype WHERE reid=2 and ishidden<>1 ORDER BY `sortrank` ASC LIMIT 0,8 "}

<li>

<a href= "[field:typedir/]" >

<h5>[field:typename/]</h5><p>[field:ainiukeji function='cn_ Substr (@me, 180)'/]</p>

</a>

</li>

{/dede:sql}


The most important thing is the value of Reid, which top level column it represents. Typename is the column name (title) and typedir is the column address (URL).


Hot recommendation

technical college

Shou Yu network provides technical knowledge for website construction, SEO optimizes knowledge and server technology knowledge.

Station College

SEO tutorial

Server knowledge

DEDECMS SQL statement calls the title and URL of all sub columns under the specified column.

Date: 2019-11-20 20:36 first royal online browsing: 180 times

The DEDECMS SQL statement calls the title and URL of all sub columns under the specified column.


{dede:sql sql= "SELECT typename, typedir, ainiukeji, com FROM dede_" Arctype WHERE reid=2 and ishidden<>1 ORDER BY `sortrank` ASC LIMIT 0,8 "}

<li>

<a href= "[field:typedir/]" >

<h5>[field:typename/]</h5><p>[field:ainiukeji function='cn_ Substr (@me, 180)'/]</p>

</a>

</li>

{/dede:sql}


The most important thing is the value of Reid, which top level column it represents. Typename is the column name (title) and typedir is the column address (URL).


Website template