|
|
Joined: Jun 2002
Posts: 160
Member
|
Member
Joined: Jun 2002
Posts: 160 |
What would I need to enter as a query to pull up a list of users sorted by location?
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
SELECT U_Username,U_Location FROM w3t_Users ORDER BY U_Location
|
|
|
|
Joined: Jun 2002
Posts: 160
Member
|
Member
Joined: Jun 2002
Posts: 160 |
Thanks. I've got half a dozen e-books on PHP and mySql on my task list, but have been so busy with other things, I haven't gotten around to learning even the basics yet.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 70
Joined: January 2007
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|