i want to send a email for more than one recipients automatically every day 8:00 AM output of following sql Query
$sql10 ="SELECT `X`.`wdate`,`X`.`line`,`X`.`style_no`,`X`.`po_no`,`P`.`order_qty`,`X`.`Line_O ut`,`X`.`Final_QC_Out`,`X`.`Iron_Out`,`X`.`Refinal_Out`,`X`.`Packing_In`,`X`. `Warehouse_In` FROM(SELECT `Q`.`wdate`,`Q`.`line`,`Q`.`style_no`,`Q`.`po_no`,SUM(IF(`Q`.`place`='Line_Ou t',`Q`.`bsum`,0)) AS Line_Out, SUM(IF(`Q`.`place`='Final_QC_Out',`Q`.`bsum`,0)) AS Final_QC_Out,SUM(IF(`Q`.`place`='Iron_Out',`Q`.`bsum`,0)) AS Iron_Out, SUM(IF(`Q`.`place`='Refinal_Out',`Q`.`bsum`,0)) AS Refinal_Out, SUM(IF(`Q`.`place`='Packing_In',`Q`.`bsum`,0)) AS Packing_In, SUM(IF(Q.place='Warehouse_In',Q.bsum,0)) AS Warehouse_In FROM(SELECT `T`.`fac_code` , T.style_no , T.po_no , SUM( T.bcount ) AS bsum , `T`.`wdate` , `T`.`Place`,`T`.`line` FROM ( SELECT `W`.`fac_code` , `W`.`barcode_id` , `B`.`style_no` , `B`.`po_no` , `B`.`size` , `B`.`colour` , COUNT( `W`.`barcode_id` ) as `bcount`,`W`.`wdate`,`W`.`place`,`W`.`line` FROM wherin_tbl AS W , barcode_tbl AS B WHERE `W`.`barcode_id` = `B`.`barcode_id` GROUP BY `W`.`barcode_id` ,`W`.`fac_code`,`W`.`place`,`W`.`line`,`W`.`wdate` ) AS T WHERE `T`.`fac_code`='$_POST[fac_code]' AND `T`.`wdate` BETWEEN '$_POST[frdate]' AND '$_POST[trdate]' GROUP BY `T`.`line`,`T`.`place`,`T`.`po_no`,`T`.`wdate`) AS Q GROUP BY `Q`.`wdate`,`Q`.`po_no`,`Q`.`line` ) as X, po_tbl AS P WHERE `X`.`po_no`=`P`.`po_no` AND `P`.`fac_code`='$_POST[fac_code]' ORDER BY `X`.`wdate`,`X`.`line`";
My Script:
<?php
echo "<table border='1' cellpadding='3' cellspacing='0'> ";
echo "<tr> <th>Date</th><th>Line</th> <th>Style No</th> <th>PO No</th><th bgcolor='#CCCCFF'>Order Qty</th><th>Line Out</th><th>Final QC Out</th><th>Iron Out</th><th>Refinal Out</th><th>Packing In</th><th>Warehouse In</th>";
while ($row10=mysql_fetch_array($result10)){
echo "<tr>";
echo "<td>" . $row10['wdate'] . "</td>";
echo "<td> Line" . $row10['line'] . "</td>";
echo "<td>" . $row10['style_no'] . "</td>";
echo "<td>" . $row10['po_no'] . "</td>";
echo "<td bgcolor='#CCCCFF'>" . $row10['order_qty'] . "</td>";
echo "<td>" . $row10['Line_Out'] . "</td>";
echo "<td>" . $row10['Final_QC_Out'] . "</td>";
echo "<td>" . $row10['Iron_Out']. "</td>";
echo "<td>" . $row10['Refinal_Out'] . "</td>";
echo "<td>" . $row10['Packing_In'] . "</td>";
echo "<td>" . $row10['Warehouse_In'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>
database structure for email address:
email_tbl
sn | email |location |
1 |test@vtex.com | HO |
2 |test2@vtex.com |TGK |
3 |test3@vtex.com |HO |