(11-25-2017, 01:44 PM)nadeem14375 Wrote: SELECT `payment_amount` FROM `payments` WHERE `payment_student` = '44' AND date_format(fee_month,"%d-%m%Y") >= date_format(curdate(),"00-%m-%Y") AND `payment_status` =0
What result do you get without all that strange date stuff that I am unfamiliar with it. This looks wrong too "%d-%m%Y" should it be "%d-%m-%Y" (notice the additional hyphen)
