wampforum
07-12-2011, 10:31 AM
Hi folks,
hope someone can help as I have been nabngin my heda all morning on this! I am trying to create a list of user emails and name to import to mailchimp. I tried the generate mailing list option but it will not seperate data - just displays as one column regardless of linebreaks, commas anything.
Any I ran an SQL query that gave me the details fine but its only showing me 618 results - I have 1160 members on my site so why are they not showing on the generate mailing list or SQL results? I get the same issue if I run the query via phpadmin - usertable shows 1160 entries but only produces 6128 on query
The SQL I ran was:
SELECT email FROM user
Also anyway of pulling real names into the SQl query?
cheers
Brett
--------------- Added 1310482763 at 1310482763 ---------------
OK I have sorted things!
hope someone can help as I have been nabngin my heda all morning on this! I am trying to create a list of user emails and name to import to mailchimp. I tried the generate mailing list option but it will not seperate data - just displays as one column regardless of linebreaks, commas anything.
Any I ran an SQL query that gave me the details fine but its only showing me 618 results - I have 1160 members on my site so why are they not showing on the generate mailing list or SQL results? I get the same issue if I run the query via phpadmin - usertable shows 1160 entries but only produces 6128 on query
The SQL I ran was:
SELECT email FROM user
Also anyway of pulling real names into the SQl query?
cheers
Brett
--------------- Added 1310482763 at 1310482763 ---------------
OK I have sorted things!