How can I output

[mclark2112]

I would like to output all my member's user names to a text file, with just a space between the names? I know this is probably a simple sql statement, but I have no clue how to do it. Like this:

John Bill Frank Barry Mke A Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Adam Bobby John Bill Frank Barry Mke Adam Bobby John Frank Barry Mke Adam Bobby

My goal is to make a t-shirt that has, among other things, all the members names on it. So I need the names to make the screen. May use it for a subltle background for some pages too. I have about 3000 members right now. Oh, I would want to make sure banned members do not show up on this list, although I could manually remove them too.

[peterska2]

Try this

SELECT username FROM user WHERE usergroupid <> 8

Just make sure your banned users are in usergroupid 8

[mclark2112]

That seems to spit out a vertical table when I run the query filled with the usernames. I can dump the user table into a text file, but that has all the extra fields in it. If it could just be usernames, I could get rid of the quotes nd commas easy enough...

[Marco van Herwaarden]

Just copy all the names in the query output to a decent text editor that let you replace the End-Of-Lines with a space.

[mclark2112]

OK, I dumped the user table, copied the username column into word as text. Then I replaced all the paragraph marks with 2 spaces. The output is perfect. Now to figure out how to make my design....