I need to list all the registered members in my phpBB3 forum from the database urgently. I'm not familiar with MySQL database but have tried Googling around.
In other word, I need to have all users and their email address from my database. I've tried the following SQL Query but seems that I got some error.
Can anyone assist on how to generate username & email in one list?
SELECT COUNT( * ) AS 'Rows', 'user_email', *
GROUP BY 'user_email'
ORDER BY 'user_email'