script to generate mailing list System

[kh99]

Do you have something like phpMyAdmin to do database stuff? You could do this:

SELECT email, username, birthday, gender, field2 AS location
FROM user LEFT JOIN userfield USING ( userid )

and then export the result as a CSV. Problem is the above won't work as is because there's no gender column in either table, so if you have a gender column then you can change "gender" to whatever column you want.