[Vince]

This is pretty much the simples of SQL queries that exist. I suggest you read up on SQL some more.

PHP код:

SELECT playername FROM clan_members WHERE clanname = 'blah' 


Then use a while-loop to fetch results.