SEO

I thougth this might be worth a shot.

Ok, well i thought about emailing all my old users that where in my old forum i could never get to import. So they could know about the new forum etc.
Is there some sort of sql comand where i can get it to out put 1 field in a db table with maybe a comma between them. Just a list of all the email address in my db?

Its an mysql db. I have the tables sql file dl but i dont' want to copy paste 400 emails addys.

Do you still have the old database ?
If yes the following way shall help you. Download and install xampp to your computer and install your old forums software to your pc. Then dump the database over the existing one. There you can import the e-mails pretty easy.

You can do SELECT emailaddress FROM tablename

That will give you a one-column list. Then you should be able to use a text editor and do a search/replace for a CR and replace it with a comma or semi-colon.

__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum

Thanks very much, keith. Worked like a charm. Now lets see how many of my very old users pop there head back in.