Member Avatar for Rizi004

Hi every one
any one tell me that if i post an article on my website and i want that the article don't disply after one month? In my table there is a field of date which save the date of the artcile when it is posted and one field of table is isExpire. The isExpire show 0 after one month other wise it will show 1. Now tell me how i can make this function that check that the posted article how much old???

waiting for your reply
Thanks in advance

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 12 Minutes Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

You can use DATEDIFF in your query. That would eliminate the need for the isExpired column.

Edited by pritaeas
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.