'".$_POST['mete']."')"; } else{ $where="(Material <> '".$_POST['mete']."')"; } } //echo $where; for($i=$weekno1 ; $i <= $weekno2 ; $i++) { $sql3="Select * From Ref_Weekno_Master where Week_No='".$i."' AND yearno='$weekyear'"; // echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'"; $result3=mysqli_query($conn,$sql3); $record3=mysqli_fetch_array($result3); $weeknostart=$record3["From_Date"]; $weekstartfor=date('d-M', strtotime($weeknostart)); $weeknoend=$record3["To_Date"]; $newdate = strtotime ( '-1 day' , strtotime ( $weeknoend ) ) ; $newdate = date ( 'Y-m-j' , $newdate ); $weekendfor=date('d-M', strtotime($newdate)); $sql6="Select sum(Quantity) as steelframe From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Material<>'AL'"; // echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'"; $result6=mysqli_query($conn,$sql6); $record6=mysqli_fetch_array($result6); $steelframe=$record6['steelframe']; $sql4="Select sum(Quantity) as unweld From Ref_WeldingNew1unweld where FTYETA Between '$weeknostart' AND '$newdate'"; // echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'"; $result4=mysqli_query($conn,$sql4); $record4=mysqli_fetch_array($result4); $ttlunwelded=$record4['unweld']; /* $sql4="Select sum(Quantity) as steelframe From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Material='Steel'"; // echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'"; $result4=mysqli_query($conn,$sql4); $record4=mysqli_fetch_array($result4); $ttlwelded=$record4['weld']; */ $ttlframes=$ttlunwelded+$ttlwelded; ?>