织梦栏目mysql调用_dede调用文章的栏目，作者，发布时间.以及连接数据库输出一个表...

发布时间：

{dede:field.pubdate function="MyDate('Y-m-d H:i',@me)"/}

类目：{dede:field.typename/}

发布人：{dede:field.writer/}

$con=mysql_connect("localhost","root","120911");

if(!$con)

{

die('Could not connect'.mysql_error());

}

mysql_select_db("dedecms",$con);

$result=mysql_query("

select*from dede_archives where arcrank=-1"

);

echo "

ID

选择

文章标题

更新时间

类目

发布人

操作

while($row=mysql_fetch_array($result))

{

echo "

";

echo "

".$row['id']."";

echo "

";

echo "

".$row['title']."";

echo "

".$row['pubdate']."";

echo "

".$row['keywords']."";

echo "

".$row['writer']."";

echo "

";

echo "

";

}

echo "

";

mysql_close();

?>