<?php include ("../inc/db.php"); include ("../inc/phpmkrfn.php"); include ('../inc/xtpl.php'); $t_AUTOID=$_GET['AUTOID']; if (empty($t_AUTOID)){$t_AUTOID=-1;}; $t_KUCID=$_GET['KUCID']; $xtpl=new XTemplate ("listdelt.html");	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);    $sSql ="select kuchen.*,ID,SUM(KUC02) AS KUCTOL,PROD01,PROD04,PROD05 from kuchen LEFT JOIN products ON kuchen.KUC01 = products.ID  where kuchen.KUC01='$t_KUCID'  group by kuchen.KUC01 ";	$rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);    $row = mysql_fetch_array($rs, MYSQL_ASSOC);		$deltid=$row[KUC01];   //送貨明細(xì)編號(hào)		$xtpl->assign("mDATA",$row);		/* assign array data */	//**************************************************	$sSql ="select kuchen.*,ID,PROD01,PROD04,PROD05 from kuchen LEFT JOIN products ON kuchen.KUC01 = products.ID  where kuchen.KUC01='$deltid'";	$rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);    while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {		$xtpl->assign("DATA",$row);		/* assign array data */		$xtpl->parse("main.table.row");			/* parse a row */	}	$xtpl->parse("main.table");		$xtpl->parse("main");	$xtpl->out("main");?>