![]() |
How can I output
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:
Quote:
|
Try this
[sql]SELECT username FROM user WHERE usergroupid <> 8[/sql] Just make sure your banned users are in usergroupid 8 |
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...
|
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.
|
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....
|
All times are GMT. The time now is 06:03 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|