Reset a whole row..

[Chevy]

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?

[AndyB]

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

[paul2463]

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