SELECT from_unixtime( cdb_posts.dateline, '%Y-%m-%d' ) AS date1, cdb_forums.name, count( cdb_forums.fid ) AS threadcount
FROM `cdb_forums` , `cdb_posts`
WHERE cdb_forums.fid = cdb_posts.fid
GROUP BY from_unixtime( cdb_posts.dateline, '%Y-%m-%d' ) , cdb_forums.name
ORDER BY date1 DESC
我使用uhome的数据调用(sql代码如上),在uhome的数据调用里面浏览是可以看到查询结果的,但是我把“Javascript调用代码”及“<script language="javascript" type="text/javascript" src="http://bbs.chengme.com.cn/home/js.php?id=17"></script>”放到了html文件中,打开html文件就是显示不了结果 |