โค้ด: เลือกทั้งหมด
$sql = "SELECT DAYIN FROM WDATA
WHERE dayin BETWEEN ".set_f_date($sql_m_b)."
AND ".set_f_date($sql_m_e)."
AND PRODUCT IN ('001','003','014','015')
GROUP BY DAYIN
ORDER BY DAYIN ASC ";
$rows = $dbf_db->GetAll($sql);
echo $sql; ออกมาได้ SELECT DAYIN FROM WDATA WHERE dayin BETWEEN #08/01/06# AND #08/31/06# AND PRODUCT IN ('001','003','014','015') GROUP BY DAYIN ORDER BY DAYIN ASC 2006-08-01
นำ $rows มาวน loop เป็น array ตามรหัส
โค้ด: เลือกทั้งหมด
$a_product = array('001','003','014','015');
foreach($rows as $k=>$v) {
foreach($a_product as $r=>$d) {
$sql = "SELECT SUM((W1-W2)/1000) FROM wdata
WHERE PRODUCT='".$d."' AND DAYIN=".set_f_date($v[0])." ";
$row = $dbf_db->getRow($sql);
}
}
echo $sql; ออกมาได้
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/01/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/01/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/01/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/01/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/02/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/02/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/02/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/02/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/03/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/03/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/03/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/03/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/04/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/04/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/04/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/04/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/05/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/05/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/05/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/05/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/07/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/07/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/07/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/07/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/08/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/08/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/08/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/08/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/09/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/09/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/09/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/09/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/10/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/10/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/10/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/10/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/11/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/11/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/11/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='015' AND DAYIN=#08/11/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/12/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='003' AND DAYIN=#08/12/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='014' AND DAYIN=#08/12/06#
ข้อมูลมีถึงวันที่ 12
แต่ถ้าลองวน loop แค่รหัส 001
โค้ด: เลือกทั้งหมด
foreach($rows as $k=>$v) {
$sql = "SELECT SUM((W1-W2)/1000) FROM wdata
WHERE PRODUCT='001' AND DAYIN=".set_f_date($v[0])." ";
$row = $dbf_db->getRow($sql);
}
echo $sql; ออกมาได้
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/01/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/02/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/03/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/04/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/05/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/07/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/08/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/09/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/10/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/11/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/12/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/14/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/15/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/16/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/17/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/18/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/19/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/20/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/21/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/22/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/23/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/24/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/25/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/26/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/28/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/29/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/30/06#
SELECT SUM((W1-W2)/1000) FROM wdata WHERE PRODUCT='001' AND DAYIN=#08/31/06#
ได้ข้อมูลถึงวันที่ 31
** จะทำยังไงให้วน loop แบบ array แล้วให้แสดงข้อมูลถึงวันที่ 31 คะ