MySQL Help?

Keyz333 · 13-09-2009, 03:28

Ok, I have recently set up a type of online messenger, and I would like to have a members list on one of my HTML pages.. I just need a line of code which will list the names in a certain part of the MySQL DB.

EG The table is called Users and inside I just need the 'username' to be shown, in a list, of all the members.

Thanks alot in advance.

Jon T · 13-09-2009, 09:14

Try this: http://www.astahost.com/info.php/Dis...st_t19036.html

punky · 13-09-2009, 10:32

Quote:

Originally Posted by Keyz333

Ok, I have recently set up a type of online messenger, and I would like to have a members list on one of my HTML pages.. I just need a line of code which will list the names in a certain part of the MySQL DB.

EG The table is called Users and inside I just need the 'username' to be shown, in a list, of all the members.

Thanks alot in advance.

Code:

SELECT username FROM Users;

will do the job. If you want to sort then:

Code:

SELECT username FROM Users ORDER BY username ASC

Keyz333 · 13-09-2009, 13:12

Thank you!