smarty 数据库整理

获取栏目的class信息 bname btitle

public function user_getclassinfo($classid)
{
	$query = "select c1.classurl,c1.filetype,c2.cnavname,c2.cnavurl,c1.classimg,c1.intro,c1.bname,c1.classpagekey,c1.classname,c1.sonclass from kk_enewsclass as c1,kk_enewsclassadd as c2 where c1.classid = c2.classid and c1.classid = $classid";
	$command = $this->connection->createCommand($query);
	$classdata =  $command->queryAll();
	$classdata = $classdata [0];
	$classdata["classid"]=$classid;
	return $classdata;
}