Weaving dream Dedecms Invoking the database arbitrary content with SQL statements

DedeCMS Multi-site data uses SQL segments to invoke data methods with each other:
2 or more Dede stations how to call each other data, non-JS call, if 2 or more dedecms sites are installed in the same database of different data tables, in order to realize the function.
Here's how:

{dede:sql sql= "select ID as Tmd,title from ' the database name of a different station '. ' Dede_archives ' ORDER by tmd desc LIMIT 0,10"}
<li><a href=http://www.dedesky.com/plus/view.php?aid=[field:tmd/] title= "[field:title/]" target= "_blank" >[field:title/]</a></li>
{/dede:sql}

Modify the red part of the above code to the name of the database you want to call, and change the www.dedesky.com to your site URL.

Original: http://www.dedesky.com/dedetech/20111209/237.html

Weaving dream Dedecms Invoking the database arbitrary content with SQL statements