robjay
asked on
How do I list everything in database
Hi, I am trying to make a member list, I need to list everyone in a page, the database is users, but I don't know how to use one of these codes: $getusers = mysql_query("SELECT * FROM `users` ORDER BY `id` ASC") or die(mysql_error());
and then echo "$getusers";
So, what i'm asking, what am I doing wrong? Or is there a better way of doing this that I don't know about?
and then echo "$getusers";
So, what i'm asking, what am I doing wrong? Or is there a better way of doing this that I don't know about?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
k_murli_krishna
If database is users, you should SELECT from it and you should from the concerned table instead.
Sorry typo, you should not SELECT from users (which is the database according to you).