Print

[mustang_lex]

I have the SQL query that resets votes and ratings for cpg133_pictures, now I need the query that sets all the tables in cpg133_votes to 0 as well. Whats happening is I want to reset votes and ratings every month and let the members revote again as the new months come. But they can't because cpg133_votes logs their votes.

I already did reset the table through PHPMYADMIN , but I just want to be able to run a simple query like the one that resets the votes and ratings.

Thank you

[Nibbler]

Code: [Select]

TRUNCATE TABLE `cpg133_votes`

[mustang_lex]

Thank You!!!!