[Dion]

I have a mysql database with my php website, and 1 of the fields in my database is a number.
Every 30 minutes a number has to be added to the previous number

Ex.
time=10.00 number=5
time=10.30 number=6
time=11.00 number=7


I know how to add a number to the database number using SET, but how can I make the code in a way that the number is added every 30 minutes??


thanks in advance

Dion

[RynO]

Well, depending on your server access and your operating system, you could set a cron job up to operate every 30 minutes.

That's what I do on my site and it works pretty good.

If you have cpanel than just scroll down to the cron job icon.

[Dion]

what do you mean with cpanel?
and do you have to install something to get cron or is it standard php?

[jamslam]

cPanel is an administration tool used to help administate your site. Your best bet would be to ask your host if you have cPanel, and subsequently ask your host if cron jobs are allowed (cron jobs aren't dependant upon cPanel).

Cron Jobs also aren't directly related to PHP- cron jobs is simply a way of 'executing a file every timeframe'...

[Dion]

well, uhm asking my host is a bit of a prob. I'm using apache to host it myself, so...

[<?Wille?>]

well.. you could also make a small snippet to check current time (mktime) in the beginning of your view table script and if 30mins have elapsed then add the number.. if 1 hour add 2 numbers.. this will make it seem like its adding every 30mins becourse everytime someone trys to view the table contents it adds the numbers if enough time has elapsed..
hope it helps
Wille