DELETE FROM table1
USING table1, table1 AS vtable
WHERE (table1.ID > vtable.ID)
AND (table1.field_name=vtable.field_name)

You may need to have lots of ANDs at the end, if you want lots of...

I guess it depends on how you define truly. If you mean, the owner/admin dies, and yet somehow 3 years later the forum is still humming along, then, yeah, no forum is that self-sustaining.
...

It wouldn't be spam if you could partner with a site that is already established in your market. I've done that with email newsletters -- I find a site for writers, find out how much it costs to...

You want people to give you advice on spamming?

-Tony

I see you on The Admin Zone every now & then. :)

I'm a member of TAZ, Daniweb, Sitepoint, v7, Digital Point, webmaster-talk, Ozzu, talk-freelance, phpbb.com, and maybe 30 more. Oh, and my own...

Mmm. Cain goes way back. Nice. I loved playing Yar's Revenge.

My list of favorite games:

Kaboom! on Atari 2600 - they encouraged gamers to take a photo of their TV if they got a high enough...

Not only that, it promotes quality discussion, because the people participating don't want to drive away members. Suddenly, the top posters start to view your site the way you view it. They want to...

I'm about to implement this on one of my forums. I'm looking at Google's terms and I cannot find anything that would prohibit this. Can you explain how it violates the TOS? I don't want to get in...

SMF (Simple Machines Forum) is another free one.

My thinking is like this:

If you're poor, or if you are a free software zealot (I am -- I want the ability to freely modify & use without...

I just sent out my second newsletter, over the weekend. Poor response. :( My first newsletter went out on a Sunday and got a great response, but maybe that was just the newness of it.

I'll...

I'm not sure "penalized" is the right word. Perhaps "ignored" is better. Google doesn't want duplicate content in its index, so it tries to figure out which site holds the original text.

You can...

If you just want to build sites that will make tons of money from Google ads, then you need to build sex/relationship sites (not porn), pharmecutical/drug sites, and well, look in your spam folder. ...

Wow. I thought your comment was very harsh, so I went to the site to try to provide an alternative viewpoint. However, upon reviewing the site, I have to say that you're not far off the mark.
...

Go to www.phpbb.com and download the phpBB forum software. Unzip the downloaded file, and upload the contents to your Web server. Then pull up the installer page in your Web browser, and follow the...

Many sites have tens of thousands of articles/tutorials/etc. So no, I don't think you can overdo that. Every page is a potential landing page for a visitor who was searching on Google.

There are...

Wow, if you're actually going to do it, let me give you some tips.

First, you can blow your whole budget in an hour, if you pick keywords that are too broad. If that happens, it's not a total...

That's pages per visit, not hits? Wow. That's really, really incredible. You have a very sticky site. I'm going to stop by and try to learn from you.

-T

Really? That's primarily what I like it for. It's perfect for the obscure old threads that I'll never remember to check, unless there is a reminder.

But I do have a strategy for managing the big...

Yes, I love that too. In fact, I wrote the mod for phpBB that switches the default to "enabled." However, oddly, it's about the least-downloaded mod I've got. I think forum admins might not...

DanceInstructor, dojo, Dustin, thank you all for the input. I eventually slogged through it. I ended up banning SIX people, including the moderator, no chance (or desire) of making it up with her...

Well, if the ideas mentioned won't work, that may just be a difference in size -- your almost 70K membership causes issues that those of us with 5K memberships don't experience. That's OK. But...

By the way, your idea about polls does work. I'm sure you've seen Slashdot's poll on the right side of their site. Every week (or two), they have a new poll. All they have to do is set it up, and...

I did a contest that required examining every response, but it didn't take much time on my part at all. Here's what I did: I wanted a new logo, and I offered $250 to the winner. Each entry needed...

Here's what I'm working toward for email. I'm creating a short email (just a few paragraphs) that contains links to the best topics, and mentions a couple of the newest site features. I'll send it...

I was always impressed by welcome PMs. However, I have to admit that it never made me post more. It just gave me a warm fuzzy feeling.

One of the best ways (I think) to get rid of 1-post wonders...

I did that, and regretted it. I'd much rather use a paid service, even considering how weak their services are.

The people I did post exchanges with posted terribly. One guy just copied posts...

I have a plea for advice from admins of large, successful forums. I'm in a bind. I run a few forums, and finally created a successful one. But last week, one of the moderators posted some material...

Huh? You can do a 50 cent Adwords campaign, if you want. Google will let you spend however much or little you wish.

-Tony

You can't even afford $10 for Google Adwords? Without some kind of boost at the beginning, you're going to grow VERY slowly.

I guess if I had absolutely zero dollars, my best way to promote would...

On December 19th I purchased 100 posts from both Forum Elves & Forum Launch. Days went by with no further activity. Finally, on December 31st, I saw a batch of registrations and lots of posting from...

If he's going to manage the PPC campaign himself, then he's smart to be allergic to it. However, if you're proposing to run it for him, then he's crazy to assume that his limitations apply to you...

For one of my sites, 7.59 pages/visit.

-Tony

Yeah, she's cute, but her face has no mystery to it.

However, I could watch her hips for a few hours. ;)

-Tony

It's nice to have you with us. Welcome!

-Tony

Welcome!

I wrote a few posts a while ago that outlined things I was doing to keep members & get better conversions. Here's a recap:

Remove barriers to entry. When I put my site up for review on a few...

You know, contests really worked for me. I should have mentioned that in the other topic you have on traffic-building.

Anyway, I did a bounty -- $1 per magazine entered into my database. I ended...

Yeah, I agree with Dani. On my site, I run a query on the database every month or two, to get a list of all the members who have not even activated their accounts. I send them a reminder email with...

My site is smaller than yours. I run a forum site with only about 2000 members. I also have a couple technology sites. Here are the things that caused a rise in traffic:


PR Web press release...

If your service really is for posting resumes, I imagine that you'll get eaten alive by the big fish in that pond. How will your site compete against monster.com, guru.com, and the 100 other sites...