What I have done today ??
hehe
again mengeksplore mysql..huhu mmg best raser nyer
dekat setengah jam try camner nak cari interval date..
nk date less than 30 days..
klu guner LIMIT and other select tuh. buleh kot tp nak try
guner MySQL nyer function so hasilnya

klu nak more than 30 days
(cst_date >= CURDATE() AND cst_date <= DATE_ADD(CURDATE(), INTERVAL 30 DAY))

camner nk less than 30 days
DATE_SUB(CURDATE(),INTERVAL 4 DAY) <= cst_date && ( cst_date <= CURDATE())

* klu guner DATE_SUB tuh ajer dier akan return all days gak..
tu aa yg membuat aku penin.. kener tambah "cst_date && ( cst_date <= CURDATE()"
yg nie baru jadie

*semuer nie ader dlm manul MySQL...

:: 21 Ramadhan :: wah puasa nk habis