关键字比较简单呀,比如每条新闻又个字段用来存储关键字,那么提取某条新闻的时候就顺便把具有改新闻关键字相同的新闻也提取出来。数据库结构: CREATE TABLE `news` ( `id` INTEGER(11) NOT NULL, `date` INTEGER(11) NOT NULL, `author` VARCHAR(50) NOT NULL, `content` TEXT NOT NULL, `keyword` VARCHAR(50) NOT NULL, `access` INTEGER(11) NOT NULL) TYPE=MyISAM ;里面的keyword字段就是用来存储关键字的!!
CREATE TABLE `news` (
`id` INTEGER(11) NOT NULL,
`date` INTEGER(11) NOT NULL,
`author` VARCHAR(50) NOT NULL,
`content` TEXT NOT NULL,
`keyword` VARCHAR(50) NOT NULL,
`access` INTEGER(11) NOT NULL)
TYPE=MyISAM ;里面的keyword字段就是用来存储关键字的!!
js:
<script src="xgnews.php?id=<?=$news_id?>"></script>xgnews.php:
for ($i=0;$i<5;$i++)
echo "document.write('<tr><td height=20> <a href=../../../files/".@mysql_result($rs,$i,"filename")." target=_blank title=".@mysql_result($rs,$i,"news_title").">".$wg->showtitle(@mysql_result($rs,$i,"news_title"),60)."</a></td></tr>');";