หาคนสอน php เร่งด่วนมากค่ะ เกี่ยวกับการออกรายงานกันซื้อขายสินค้าหน้าร้าน

$sql="SELECT * from basket";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
	$basid=$row['bas_id'];
	$basname=$row['bas_name'];
	$basqty=$row['bas_qty'];
	$basprice=$row['bas_price'];
	$baspoint=$row['bas_point'];
	
$sqlca="SELECT sum(bas_price) from basket";
$resultca=mysql_query($sqlca);
$rowca=mysql_fetch_array($resultca);
	$sum=$rowca[0];
	

function changeD($Y){
	
	$Y1=substr($Y,0,4);
	
	$newY=$Y1;
	
	return $newY;
	}
	
$date=date("Y-m-d");
$Y=changeD(date("Y-m-d"));


$sql1 = mysql_result(mysql_query("Select Max(substr(order_id,-5))+1 as MaxID from ordersale"),0,"MaxID");
	if($sql1==''){ 
   		$order_id="$Y-00001";
    }else{
		
		
   		$order_id="$Y-".sprintf("%05d",$sql1);
 	}
			
	
if($row){
	$sql2="INSERT INTO ordersale values('$order_id','$idname','$date','$sum')";
	$result2=mysql_query($sql2);
		if($result2){
			$sql3="select * from basket";
			$result3=mysql_query($sql3);
				while($row=mysql_fetch_array($result3)){
					?????";}
				}
		}else{
			echo "ไม่ได้";
		}

<?
include('connect.php');
$xmonth[6];
$xmonth[7]="jul";$xmonth[8]="aug";$xmonth[9]="sep";$xmonth[10]="oct";$xmonth[11]="nov";$xmonth[12]="dec";
$sql="select CITIZEN_ID from year55 ";
$qr = mysql_query($sql,$objConnect);
$i=1;
 while($rs=mysql_fetch_array($qr))
{
	$yeartable="year55";
	$sql1="select *  from $yeartable where CITIZEN_ID='".$rs["CITIZEN_ID"]."'";
	$qr1 = mysql_query($sql1,$objConnect);
	$num = mysql_num_rows($qr1);
	echo $qr1."<br>";
	while($rs1=mysql_fetch_array($qr1))
	{
	if($num !=0)
		{
			for($j=6;$j<12;$j++)
				{
					$sql2="select  ".$xmonth[$j]."  from year55 where CITIZEN_ID='".$rs["CITIZEN_ID"]."'";
					$qr2 = mysql_query($sql2,$objConnect);
					$rs2=mysql_fetch_array($qr2);
					$xxmonth=$xmonth[$j];
				//	echo $sql2. "<br>" ;
				$sql3="Insert into t_empfund(CITIZEN_ID,fund_month,fund_year,debit_value) Values ('".$rs["CITIZEN_ID"]."', '".($j+1)."','2012',".$rs2[$xxmonth].")";
						if(!mysql_query($sql3))
						{
						echo $i.". [".$rs1["ID"]."] ".$sql3."<br>";
						}
						//echo $i.". ".$sql3."<br>";*/
						
					//echo $i.". ".$rs["stf_fname"]."--".$rs["stf_lname"]."<br>";
				$i++;
				}
			
		}
	}mysql_free_result($qr1);
$i++;
}mysql_free_result($qr)
?>