<?php
  include_once 'global.php';
  
  //作品的基本信息
  if(!empty($_GET['id'])){
	$sql="SELECT a.*,b.*,c.name FROM `n_productbase` as a, `n_productcontent` as b ,`n_productclass` c WHERE a.id=b.nid and  a.cid=c.id and  a.id='$_GET[id]'";
    $query = $db->query($sql);
    $row_product = $db->fetch_array($query);
  }
  $smarty->assign("row_product",$row_product);
  
  //作品的详细图片
  if(!empty($_GET['id'])){
  	$sql="select b.pictures from n_productcontent a,n_uploadpic b where a.sessionid=b.sessionid and a.nid='$_GET[id]'";
  	$query = $db->query($sql);
  	while ($row_productpic = $db->fetch_array($query)){
  		$ly_pictures[] = array(
  			'pictures'=>$row_productpic['pictures'],
  		);
  	}
  }
  $smarty->assign("ly_pictures",$ly_pictures);
  
  $smarty->display("product_view.html");
?>