How to call the topic page description and link on dedecms homepage

How to call the topic page description and link on the dedecms homepage?

The example in this article describes the implementation method of calling the topic page description and link on the dedecms homepage. Share it with everyone for your reference. The specific analysis is as follows:

Recommended study: 梦Weavercms

Because the website I recently built uses thematic pages, and the homepage calls the description of thematic pages, I have found some methods. It was unsuccessful. Later, I asked a database expert to write a sql statement for me. I found that the problem turned out to be the sql statement. The statement I wrote was too cumbersome and error-prone. After working on it for several days, I finally wrote it. I would like to share it with you first, hoping to clear up the doubts of friends who have this problem.

The code is as follows:

{dede:arclist id=11 row=1 channelid="-1" type="spec." } 
[field:array runphp='yes'] 
global $dsql; 
@me =@me['id']; 
$sql = "select t.description from dede_addonspec a, dede_archives t where a.aid=t.id and t.id=11"; 
$dsql->Execute('a',$sql); 
$one = $dsql->GetArray('a'); 
@me =substr(Html2Text($one['description']),0,660); 
[/field:array]... 
[field:typename/] 
{/dede:arclist}

I hope this article will be helpful to everyone's dedecms website building.

The above is the detailed content of How to call the topic page description and link on dedecms homepage. For more information, please follow other related articles on the PHP Chinese website!