How to generate user list in phpBB3 from phpmyadmin?

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?
Thanks!
SELECT COUNT( * ) AS 'Rows', 'user_email', *
FROM phpbb_users
GROUP BY 'user_email'
ORDER BY 'user_email'
LIMIT 100

Open in new window

SQL-Error.jpg
meowsmartAsked:
Who is Participating?
 
compfixer101Commented:
try this
SELECT `username`,`user_email` FROM  `phpbb_users` LIMIT 0,30
0
 
compfixer101Commented:
shoot forgot to remove the LIMIT 0,30
all that does is limit it to 30 results per page..
0
 
meowsmartAuthor Commented:
Hey man! It really works!!
Thanks heaps!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.