[SOLVED] how can i do this...

[edawg]

hi, how can I clear rows from a table field?.

 

I have a table set up, and what I want to do is count some votes, but once a week I want to clear all the votes to have them return to zero, so that way I can count fresh results for the new week?.

[Wildbug]

Either

UPDATE vote_table SET vote_column=0 /* Reset a row */

or

DELETE FROM vote_table /* Delete all rows; add a WHERE clause to delete some rows */ 

 

It depends on how your table/voting system is set up.

[edawg]

WILDBUG YOU ARE THE MAN!!!!!!!!!!!!!!!!!!!!. thanks a million mate!.

[fenway]

Either

UPDATE vote_table SET vote_column=0 /* Reset a row */

or

DELETE FROM vote_table /* Delete all rows; add a WHERE clause to delete some rows */ 

 

It depends on how your table/voting system is set up.

TRUNCATE also works... and resets the auto_increment counter.