News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Pm email notify encourage all members.

Started by brunob, October 14, 2013, 04:58:31 PM

Previous topic - Next topic

brunob

Hello,

I'm using the following.

I want all the zeros in Table pm_email_notify zero on a set.

How can I do this all at once? Involves more than 1,000 members to do so manually each is almost impossible to do.

Can do this through phpadmin? and then build through query?

Regards Bruno

margarett

That's a nice name you have :P

I've never ever see this kind of DB type but you should look into something like
UPDATE table_name
SET column_name = 0

This would work in MySQL...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Herman's Mixen

Bruno please do not cross post between boards you already have your answer in the Dutch boards ;)
Met vriendelijke groet, The Burglar!

 House Mixes | Mixcloud | Any Intelligent fool can make things bigger, more complex, and more violent.
It takes a touch of genius - and a lot of courage - to move in the opposite direction. - Albert Einstein

Former Godfather of our dutch community ;)

brunob

Hello The Bulgar,

there are people the don't  can't read Dutch  ;) And they also don't speak Dutch  ;D

I will ensure you that I do not do that again about cross posting.

Greetings (groetjes) Bruno  ;D




Advertisement: