Extract users emails from myphpadmin

cheekychap · #1 10th November 2010, 07:31

hi,
how can i extract users emails from myphpadmin??
Or even better send a mass email from there to my users??

mmisu120000 · #2 10th November 2010, 09:44

From phpmyadmin you cannot send mails ...

You can extract the emails in phpmyadmin with this sql query :

PHP Code:


			
SELECT `email` FROM `users` WHERE 1

My guess is that you have just a database and you want to send spams to others to increase your user number, but I may be mistaken.......
Otherwise, if you had your own database, you could send mass mail through the tracker mailer ....

Good luck!

cheekychap · #3 10th November 2010, 10:27

hi,
thanks for your help, and no its not for spam, its an old site i own, and it never had a mass emailer on there, so i was abit stuck, also how do i send, or where can i send a mass email from???
well i mean where is the tracker mailer, i know i have one somewhere

BTW :-
i got this in return from that queary :-
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`email` LIMIT 0, 30' at line 1

daffy · #4 10th November 2010, 11:01

i could write you one/fix you up no problem but il not help you out no more, i spent 3-4 WHOLE days and early mornings to help you and gotten it all thru back in my face! find help on the official forums, im sure you can get help there, oh your banned lol nevermind.