I have a field Status in my table message Its value when any message is entered in table is 1 but I want to alter it to 0 after 1 day of message posting how can I do so Plz help me
on *nix use a cron job to call a php script.
Running PHP cron jobs – regular scheduled tasks in PHP
Or simply add a timestamp to the row and verify that the value hasn't expired whenever your application uses and, if it has, UPDATE the table.
dagon;10948123 wrote:on *nix use a cron job to call a php script. Running PHP cron jobs – regular scheduled tasks in PHP
hello thanx for your help . I know this happens with cron job but I dnt have any idea abt it can u plz help me?? Thanx a lot
kanika;10948180 wrote:hello thanx for your help . I know this happens with cron job but I dnt have any idea abt it can u plz help me?? Thanx a lot
OOps Sorry I had not seen the url but now I get it This url will help me a lotI Appreciate ur help Once Again Thanx a lot
go with bradgrafelman's idea, he's more likely to be right than i am :-)
Eh, there's not always a right or wrong answer to a question. I was just offering an alternative that you could do with pure PHP code (and a DB modification) rather than depending upon a 3rd component.
