mysql auto change data

[thedarkloki]

i have a database what shows data in php and on sertion days i want some to go from active=no to active=yes so it shows the info in my php page is their anyway to make the mysql database do it its self?

thanks in advance

[fobos]

As far as i know, no. But i could be wrong. Why dont you just use the "UPDATE" statement and update the yes or no.

[Schmoopy]

You will need a cron job to do this. You can write a script that will check / update the database as you want, which you can then run at whatever times you want.

Ask your host about cron jobs, they'll be able to tell you if it's possible with your current setup.