View Full Version : Query?
Automated
10-30-2002, 03:22 PM
Could one of you Good People help me out and write the SQL query that i can throw into Phpmyadmin that will change the value of "pmpopup" in all my records to "1" so that even if the user has specified no popup when they get a PM they get one anyway :D
Thanks
Matthew
NTLDR
10-30-2002, 03:43 PM
UPDATE user SET pmpopup=1;
Automated
10-30-2002, 03:59 PM
Thanks that worked perfectly, but a bit of a sille question. I want the PmPopup to be YES for all members the value "1" is yes isnt it? Or is Yes "0" ?
Thanks for your help
NTLDR
10-30-2002, 04:02 PM
Yes is 1 No is 0 ;)
Automated
10-30-2002, 04:03 PM
thanks ;)
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.