What SQL query do i write to do this....

Hi,
I need to pull all the email addresses from my database and put them in a format like this:

,
,
,
etc..............

Here are the tables that i have

sEmailUser - table that has all the emails
sUsernameUser - table that has all the usernames
nldUser - table that has all the user id

let me know if you can...thanks

 

if you are only needing a list of emails in this format with a link, then query your email table, and add a code like below

while ($row =  mysql_fetch_array($query_string, MYSQL_ASSOC)) {
  echo '<a href="mailto:' . $row['email_address'] . '">' . $row['email_address'] . '</a>,<br>';
}

Code (markup):

should work fine for ya

 

Hi,
I dont mean to display it on a website i want a query that i can run in SQL and get results for the query i enter.

 

remove the echo part, and add in the command you want there

 

Im, looking to do the same thing and am wondering where do you input this command? Also, will it save it as a text file that I can put into my cpanel mailing list so I can group mail all members?

 

You input the command through PhpMyAdmin, and you can also export the table and certain fields (I think.) through there in certain formats.

You can also code a script to retrieve the emails and email them for you.

 

do you have php background?

the result can be saved into textfile, or placed in database, anywhere you want