Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
1
UPDATE `phpbb_gallery_images` SET `image_view_count` = '0' WHERE `phpbb_gallery_images`.`image_id` =1 LIMIT 1 ;
2 replies to this topic
#1
Posted 17 October 2010 - 06:29 AM
Bertan
-
- Members
-
- 43 posts
Learning Programmer
I want to reset the image view count of all the images on my homepage. This code I have below will set the image count to 0 to the image with id1. However I have 4000+ images on the homepage is there any way to make a command that will change image view count to 0 for all images with image id 1 to 3000?
Back to top|
|
|
#2
Posted 17 October 2010 - 02:10 PM
Orjan
-
- Moderators
-
- 3,298 posts
Writes binary right handed and hex left handed
- Location:Karlstad, Sweden
- Programming Language:C, Java, C++, C#, PHP, JavaScript, Pascal
- Learning:Java, C#
UPDATE `phpbb_gallery_images` SET `image_view_count` = '0' WHERE `image_id` <= 3000;
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall
I study Information Systems at Karlstad University when I'm not on CodeCall
#3
Posted 19 October 2010 - 10:35 AM
Bertan
-
- Members
-
- 43 posts
Learning Programmer
Great, thanks for the help :)
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
