PHP and MySQL tables
Posted: Thu Oct 28, 2010 3:08 pm
Evening Guys and Girls
I have a query about php and mysql and if it can be done or a recmmendation of the language to use.
I have a website that calls data from a database to show up and coming events of music gigs and festivals. It displays all this information in a formatted table.
I am happy with this but my question is when the gig is passed, I would like to it to be removed from the database and therefore not show on the site anymore automatically without author intervention.
Is there a function/query I can use to compare end date to system date world time etc and best use to impliment it.
Guidelines and a push in the right direction would be much appreciated
Kind regards
Cameron
I have a query about php and mysql and if it can be done or a recmmendation of the language to use.
I have a website that calls data from a database to show up and coming events of music gigs and festivals. It displays all this information in a formatted table.
I am happy with this but my question is when the gig is passed, I would like to it to be removed from the database and therefore not show on the site anymore automatically without author intervention.
Is there a function/query I can use to compare end date to system date world time etc and best use to impliment it.
Guidelines and a push in the right direction would be much appreciated
Kind regards
Cameron