is it possible to configure the update of database according the time ?

[eluser]ludo31[/eluser]
Hello ;

I mean if it's possible to update ou to delete for example the 10 last rows in database per month ou 3 months . and it does it automatically .
I would like to create a site where people can publish something that they wanna to sell , but I 'm afraid about the width of my data , so I would like to delete the old message .

s if it's possible in codeigniter


thanks

[eluser]marcogmonteiro[/eluser]
You probably want to do that in your server and not depend on codeigniter for that. Just create a routine with the necessary mysql for that and you're good to go.

[eluser]PhilTem[/eluser]
It's possible in pure PHP so it's definitely possible in CI!

Either make CronJobs or put a model's method-call into MY_Controller which automatically deletes all old data (given you have a timestamp within the tables you want to delete data from).

Have you already tried something? Then post your code snippets so it's easier for use to help you

[eluser]marcogmonteiro[/eluser]
sure it's possible, I normally just don't bother with it I do all this stuff on the server it self

[eluser]ludo31[/eluser]
Hello ;
not at all , but when I try , I posted here .

thanks

[eluser]CroNiX[/eluser]
http://ellislab.com/codeigniter/user-gui...l/cli.html
Just set up a cron job

[eluser]ludo31[/eluser]
I don't understand !! can you explain more ??with example if it's possible please