How to call dede's sql statement

How to call dede's sql statement?

SQL statement calling still has its advantages in some special circumstances. The following is an introduction to dede’s sql statement calling method. Interested friends should not miss it

Recommended: "dedecms tutorial"

The code is as follows:

{dede:sql sql='Select content from dede_arctype where id=1'}
[field:content function="cn_substr('@me',700)" /]...
{/dede:sql}

It seems to be a simple piece of code, but it is very powerful.

dede_arctype column content table

content column content field name

cn_substr() This dede commonly used string interception function

The above is the detailed content of How to call dede's sql statement. For more information, please follow other related articles on the PHP Chinese website!