Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Renaming the field from 0 to 1
hi Well i have a celebrity site where i want to allow users to DOWNLOAD images, by having the field show 1 in auth_viewimage like this auth_viewimage = 1 at the moment it shows auth_viewimage = 0 So i was wondering what query would i run to update the whole db so all cat_id from 1 to... -
Renaming the field from 0 to 1
hi guys and gals just wondering how can i rename the field auto_viewimage to 1 for all of the cat_id in my DB I used the query below to change the auth_viewimage from 0 to 1 , but would like to know the query how i can have something like UPDATE `4images_categories` SET `auth_viewimage` = '1'...
