Problem:-
I want to show only those Documents which are before the deadline of the page.
when deadline equals or less than the currentdate then show
else move to archive or send to archive file.
How to write a code for this or a query ?
as for understanding , Picture is attached.
Code for the above mentioned problem is required if possible.
THanks,
Jump to Postyou can create two separate pages for say
1) current
2) archivethe difference is only in query
for current
select * from tablename where deadline>current_date()for archive
select * from tablename where deadline<=current_date()
My deadline field in database is deadline and current date variable is $curdate
you can create two separate pages for say
1) current
2) archive
the difference is only in query
for current
select * from tablename where deadline>current_date()for archive
select * from tablename where deadline<=current_date()@urtrivedi:
Thanks Dear.
Solved!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.