global.php

xauatweb新闻网标签样板

<?
include "config.php";
function listnews($class_id,$list_num){
	global $host,$user,$pw,$db;
	$conthis=mysql_connect($host,$user,$pw);
	if(mysql_select_db($db)){
		$sqlthis="select distinct n.ID,r.title1,r.add_time from r_word r,news_view n,news_class c where n.R_word_id=r.ID and n.status=1 and c.news_id=n.ID and c.class_id='".$class_id."' order by r.add_time desc limit ".$list_num;

		$query=mysql_query($sqlthis);
		while($row=mysql_fetch_object($query))
		{	
			$rows[]=array($row->ID,$row->title1,$row->add_time);	
		}
	}
	return $rows;
}
?>