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 =)
xo_vicke93_xo 0 Newbie Poster
liamfriel 4 Junior Poster
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.
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.