PHP / SQL - Restart hit counter after 1 month

[Lucifix]

On my gallery script I would like to restart hit counter after every month.

Gallery is based on PHP and SQL.

Any idea how?

[Kudose]

You'll need to know the table and column names of the fields you're looking to dump or update.

[Lucifix]

Yes I know them:

table:
mygallery_images

column:
image_hits

[Kudose]

Call this once a month via cron job -- you will need to add the connect code.

mysql_query("UPDATE mygallery_images SET image_hits='1'");

[Lucifix]

The problem is that my host provider doesn't allow cron jobs. 🙁

[Kudose]

Then you'll need to add a field for the last date reset and use a conditional to check whether or not to run the query.

[Lucifix]

Kudose wrote:

Then you'll need to add a field for the last date reset and use a conditional to check whether or not to run the query.

That is excatly what I would like to find out.

Thx!