Good point Eliot, and I was just responding to gmoney's notes that he was looking for an EASY way to just reset the hits to zero each month, and that he was by no means a programmer.
That's also why I provided some explanation of accessing the SQL monitor eventhough you had provided the SQL query language. Some people are just starting out and it can sometimes be helpful to spell things out. When I first started with Links SQL, I sure appreciated that kind of thing. I know these things are painfully obvious to someone as advanced as you are in programming and Links SQL, but some of us aren't at that level yet.
Also, there is no need to rebuild to see if the hits have been affected. You can just go to the database part of the admin, and search for a Link to see if the hits have been reset. A rebuild would only be necessary to make the changes in Hits on the static web pages, if the Hits are included on those pages.
--Rover
That's also why I provided some explanation of accessing the SQL monitor eventhough you had provided the SQL query language. Some people are just starting out and it can sometimes be helpful to spell things out. When I first started with Links SQL, I sure appreciated that kind of thing. I know these things are painfully obvious to someone as advanced as you are in programming and Links SQL, but some of us aren't at that level yet.
Also, there is no need to rebuild to see if the hits have been affected. You can just go to the database part of the admin, and search for a Link to see if the hits have been reset. A rebuild would only be necessary to make the changes in Hits on the static web pages, if the Hits are included on those pages.
--Rover