autoincrementing a num every year.

[vidhya]

hi,

 

i have a table with 5 usersid.each user will be given a rank(1 -10) while joining.after one year completion of joining the rank of the users shd be autoincremented by itself without any triggers.(suppose a users has rank 5 while joining, the next year it shd be 6).pls help i don know how to go abt this.

is there a way to do this without any triggers.pls help me with the code.

thanks in advance

[Maq]

Just have another field in your database called next_rank.  When they sign up take the current date + 1 year.  When they hit that date (now() = next_rank) then you give them the next rank and increment next_rank by another year.  You could do this whenever they sign in or better yet run a cron job to check everyday.

[vidhya]

what do u mean by cron job?how to do that?

[samshel]

http://www.sitepoint.com/article/introducing-cron/

[Maq]

Cron jobs run scripts for you.  You need to specify the frequency of how often to run these scripts, every 10 minutes, or every Sunday at 12:00 am.

[vidhya]

In the link provided abt the illustration says the execution in linux.

how do i do it in windows?

 

how to auto start the task without linux?

[Maq]

There should be a task manager where you can schedule tasks.  There's tutorials on here for that but you should post in another section for that answer because this isn't PHP anymore.

[revraz]

Did you say you only had 5 users in the DB?

 

If so, just do it each time someone logs in instead.

[vidhya]

I gave an example as 5 users....there will be n number of users....

 

 

[samshel]

Check Scheduled Tasks..as mentioned above. I think that's what u need.