 |
|
Code (PHP)
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='29/10/2008', DOC_DATE='24/11/2009' WHERE COMMERCIAL_INV='4750029935';
OTHR0811-008,29/12/2009,31/10/2008,4750029977
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029977';
OTHR0811-008,29/12/2009,31/10/2008,4750029978
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029978';
OTHR0811-008,29/12/2009,31/10/2008,4750029979
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029979';
OTHR0811-008,29/12/2009,31/10/2008,4750029980
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029980';
OTHR0811-008,29/12/2009,31/10/2008,4750029982
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029982';
OTHR0811-008,29/12/2009,31/10/2008,4750029983
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029983';
OTHR0811-008,29/12/2009,31/10/2008,4750029984
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029984';
OTHR0811-008,29/12/2009,31/10/2008,4750029985
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029985';
OTHR0811-008,29/12/2009,31/10/2008,4750029986
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029986';
OTHR0811-008,29/12/2009,31/10/2008,4750029987
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029987';
OTHR0811-008,29/12/2009,31/10/2008,4750029988
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029988';
OTHR0811-008,29/12/2009,31/10/2008,4750029989
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029989';
OTHR0811-008,29/12/2009,31/10/2008,4750029990
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029990';
OTHR0811-008,29/12/2009,31/10/2008,4750029991
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='31/10/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750029991';
OTHR0811-008,29/12/2009,1/11/2008,4750030158
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='1/11/2008', DOC_DATE='29/12/2009' WHERE COMMERCIAL_INV='4750030158';
OTHR0811-032,26/1/2010,7/11/2008,4750030201
UPDATE COMMERCIAL_INV SET NET_DUE_DATE='7/11/2008', DOC_DATE='26/1/2010' WHERE COMMERCIAL_INV='4750030201';
OTHR0811-032,26/1/2010,7/11/2008,4750030202
นี้คะ ผลจากการ echo sql
Code (PHP)
$sSql = "SELECT * FROM COMMERCIAL_INV,EXPORT WHERE COMMERCIAL_INV.COMMERCIAL_INV='$data[7]' AND EXPORT.BOOK_ID=COMMERCIAL_INV.EXPORT_BOOK_ID;";
COMMERCIAL_INV.EXPORT_BOOK_ID ตัวเดียวกับ EXPORT.BOOK_ID นะคะ
OTHR0811-008 มันเป็นรหัส เดียวกัน แต่เลข ข้างหลังต่างกัน COMMERCIAL_INV
แล้วจะอัพเดทแค่ NET_DUE_DATE กับ DOC_DATE ซึ่งถ้า BOOK_ID เหมือนกัน NET_DUE_DATE กับ DOC_DATE ก็จะเหมือนกันคะ
ปัญหาคือ มันอัพเดท ทุกอันเลย ถ้าเราจะ group by book_id ก็ทำไม่ได้คะ
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2010-07-20 14:52:55 |
By :
แพรว |
View :
837 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
