Log in

View Full Version : reset video "views" count in database



carlsbadlocal
12-01-2008, 08:42 PM
Hi Everyone

I have a video content site with a "views" counter for each video. For testing, I need to be able to reset the view count on a few videos. (some back to zero, some to 100, etc.) I have access to the phpmyadmin for the MySQL database, but I need help figuring out how to access the views counter for those specific videos.
Any insight greatly appreciated!

james438
12-31-2008, 08:45 AM
go to phpmyadmin. login, click on the table you want to edit, check off a column that you want to edit, click on the browse icon located below the table (the first icon), check the column again and click on the pencil located below the table and you will now be able to edit all of the fields in your table.

I prefer to just create an edit program of my own for viewing the field that you want to examine and/or edit. You can use commands like
UPDATE table SET col='pop' WHERE ID=0 or something like that. It is faster and easier to navigate than phpmyadmin. phpmyadmin is handy though. I'm just saying that my personal preference is to create my own MySQL interface and yes it is quite basic, but it does what I want, is easy to navigate, and is much faster.