PDA

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 ;)