[punky]

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.

SELECT username FROM Users;

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

SELECT username FROM Users ORDER BY username ASC