How to generate user list in phpBB3 from phpmyadmin?

Posted on 2008-11-19
Last Modified: 2013-11-11
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', *

FROM phpbb_users

GROUP BY 'user_email'

ORDER BY 'user_email'


Open in new window

Question by:meowsmart
    LVL 13

    Accepted Solution

    try this
    SELECT `username`,`user_email` FROM  `phpbb_users` LIMIT 0,30
    LVL 13

    Expert Comment

    shoot forgot to remove the LIMIT 0,30
    all that does is limit it to 30 results per page..

    Author Comment

    Hey man! It really works!!
    Thanks heaps!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Title # Comments Views Activity
    updating database record after clicking on link 14 27
    scripting, exchange 35 25
    json value get in input box 6 27
    Image not there 4 0
    Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
    This article will show, step by step, how to integrate R code into a R Sweave document
    Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
    The viewer will learn how to count occurrences of each item in an array.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now