I want to know that how can i compare current job and expired date from jobs by which if the expired date exceed the job will get hide ??I am confused can anyone kindly tell me the code for that ?
WHERE CURDATE() <= jobexpiredate
Something like that?
Yup, i have done some how and that query is showing the dates which are <= current date but now i want to hide all the jobs which are expired how can i do that?
How do you know if they are expired?
Through expired date
why am i not totally surprised
The where condition I posted gives you all rows with expiration date >= current date, which should be what you want?If your current query is showing the rows with expiration date <= current date, then change the operator from < to >