falak — 2013-12-03T05:23:30-05:00 — #1
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 ?
guido2004 — 2013-12-03T06:16:41-05:00 — #2
WHERE CURDATE() <= jobexpiredate
Something like that?
falak — 2013-12-03T06:23:00-05:00 — #3
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?
guido2004 — 2013-12-03T06:54:52-05:00 — #4
How do you know if they are expired?
falak — 2013-12-03T12:21:14-05:00 — #5
r937 — 2013-12-03T12:30:08-05:00 — #6
why am i not totally surprised
guido2004 — 2013-12-03T12:46:48-05:00 — #7
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 >