script to generate mailing list System

[p@nDa]

hi all , i need a script to generate mailing list with extra fields .

i need it in this order :

mail , username , birth_date , gender , location
mail2 , username2 , birth_date2 , gender2 , location2
mail3 , username3 , birth_date3 , gender3 , location3

i need it in a csv file.

Thank u in advance to all helpers !

[p@nDa]

no way to obtain this help ? i tried some script for older vb versions , but don't work

[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.