 |
between เลือกข้อมูลเป็นเดือนระหว่างวันที่ 1/07/2555 ถึง 31/07/2555 มันไม่ได้ครับ |
| |
 |
|
|
 |
 |
|
ขอบคุณครับๆ คุณ mr.win
ลองทำตามโดยใส่ # ได้แล้วครับ
แต่บางเดือนมันก็แสดงนี้ ที่บอกให้แก้ Format แก้ยังไงครับ - -"
|
 |
 |
 |
 |
| Date :
2012-11-06 14:09:03 |
By :
newphp |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ปกติพวกนี้ชอบมีปัญหาเรื่อง Format ครับ
|
| |
|
|
| |
| Date :
2012-11-06 14:38:12 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
$strSQL = "SELECT day_work, time_in, status_in, time_out, status_out, totalstatus FROM Emp_time where EmpID='$username' AND ((day_work ='1/7/2555') OR (day_work ='2/7/2555') OR (day_work ='3/7/2555') OR (day_work ='4/7/2555') OR (day_work ='5/7/2555') OR (day_work ='6/7/2555') OR (day_work ='7/7/2555') OR (day_work ='8/7/2555') OR (day_work ='9/7/2555') OR (day_work ='10/7/2555') OR (day_work ='11/7/2555') OR (day_work ='12/7/2555') OR (day_work ='13/7/2555') OR (day_work ='14/7/2555') OR (day_work ='15/7/2555') OR (day_work ='16/7/2555') OR (day_work ='17/7/2555') OR (day_work ='18/7/2555') OR (day_work ='19/7/2555') OR (day_work ='20/7/2555') OR (day_work ='21/7/2555') OR (day_work ='22/7/2555') OR (day_work ='23/7/2555') OR (day_work ='24/7/2555') OR (day_work ='25/7/2555') OR (day_work ='26/7/2555') OR (day_work ='27/7/2555') OR (day_work ='28/7/2555') OR (day_work ='29/7/2555') OR (day_work ='30/7/2555') OR (day_work ='31/7/2555')) ORDER BY Num DESC";
ทำแบบนี้ล่ะ บายๆ
|
| |
|
|
| |
| Date :
2012-11-06 19:42:58 |
By :
newphp |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
| Date :
2012-11-07 09:00:42 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
