Cable Forum - MySQL Help?

Cable Forum (https://www.cableforum.uk/board/index.php)

- Internet Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=25)

- - MySQL Help? (https://www.cableforum.uk/board/showthread.php?t=33655288)

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.

Quote:

Originally Posted by Keyz333 (Post 34871725)

Code:

SELECT username FROM Users;

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

Code:

SELECT username FROM Users ORDER BY username ASC