vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
New vBSEO Discount Level for Network Builders Meet vBSEO Team in New York (Nov. 3rd & 4th) vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

help getting data from db table

This is a discussion on help getting data from db table within the Off-Topic & Chit Chat forums, part of the Focus on Members category; I thougth this might be worth a shot. Ok, well i thought about emailing all my old users that where ...

Go Back   vBulletin SEO Forums > Focus on Members > Off-Topic & Chit Chat

Enhancing 80 million pages.

Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read
  #1  
Old 10-24-2006, 05:15 PM
Senior Member
vBSEO Pre-Release Team
 
Real Name: chance
Join Date: Aug 2006
Posts: 218
Send a message via AIM to rocket468
help getting data from db table

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 10-24-2006, 05:28 PM
Mert Gökçeimam's Avatar
vBSEO.com Webmaster
vBSEO Total Customer SupportvBulletin HackerBig Board Administrator
 
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 7,730
Blog Entries: 1
Send a message via MSN to Mert Gökçeimam
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 10-24-2006, 05:30 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,266
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 10-25-2006, 02:12 AM
Senior Member
vBSEO Pre-Release Team
 
Real Name: chance
Join Date: Aug 2006
Posts: 218
Send a message via AIM to rocket468
Thanks very much, keith. Worked like a charm. Now lets see how many of my very old users pop there head back in.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Configurable data folder (VBSEO_DAT_FOLDER) intra2net Feature Requests 5 03-22-2006 11:08 AM
Terrorism and Transmission of Data Hanif Pre-Sales Questions 7 11-01-2005 12:49 PM


All times are GMT -4. The time now is 11:36 AM.


Powered by vBulletin Version 3.8.0 Beta 4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.