Help on MySQL statement

[sefu]

HI,

I'm wanting to test out a HTML newsletter mod that "Snowman" provided me.

I don't want to send a newsletter to everyone, just myself and the only way i can think of is to change the status of the customer newsletter from 1 to 0 in the database.

Can anyone tell me a simple statement to use in PHPMyadmin to change the status from 1 to 0 for everyone in the database. Then i will manually change my account to 1.

 

Also anyone know how to hack the newsletter code to send to the owner first?

[Guest]

I wouldn't change the status of all your registered customers to "NO", then you have lost track of who wants to get your news letter, and reversing the process to change everyone to "YES" means you will be mailing everyone that said they didn't want to hear from you, probably making most mad, and loosing them as customers because they won't trust you again.

 

I agree that a review process that involves only mailing the admin first would be a good thing. Especially as the results of email html can vary wildly from app to app. Maybe someone should look into further mods on Snowman's mod.

 

BTW, is Snowtech back up? A few of us have been missing his site.

[wizardsandwars]

A better idea would be to first change everyone that subscribes to '2', then change yours to '1'.

 

Then send yourself the email. The change everyone that subscribes back to 1.

 

 

UPDATE

 customers

SET 

 customers_newsletter = "2"

WHERE

 customers_newsletter  = "1"

 

[/code]

[sefu]

Thanks for that.

Yeah im using on a old DB so it didnt matter if the change was permanent :)