Jump to content

Archived

This topic is now archived and is closed to further replies.

Chevy

Reset a whole row..

Recommended Posts

I want to reset a whole row for all the users 1 time a day (12:00:01 AM)

It needs to get set back to 0 for everyone, is there a way to do this?

Share this post


Link to post
Share on other sites
Yes. Two things:

#1 - a script that executes the correct UPDATE query.

#2 - either cron on *nix server or Windoze scheduler on a Win server

Share this post


Link to post
Share on other sites
use some code like this
[code]
<?php

$query = "UPDATE table_you_need_to_update SET row_you_need_to_update = '0'";
mysql_query($query);


?>[/code]

and set uip a cron job on your server to run it when you want it running

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.