Member Avatar for xo_vicke93_xo

Hi, i'm not really sure how to explain this.
I have a table with a lot of places sorted by date, all connected to a MySQL database.
I'd like the table to update automatically everyday and remove the top ones where the date has passed so that the table only shows upcoming dates, does anyone know how to do that?
Thanks in advance =)

  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by liamfriel
Member Avatar for liamfriel

set up a cron job to run everymidnight and do a mysql delete where date < time() if you are storing your dates in timestamp format.

If you have cpanel setting up a cron job is quite easy.

Edited by liamfriel because: n/a
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.