SQL PHP Sort Results WordPress

Question

I am working on a user database for a Clan. I am really inexperienced with PHP and MySQL. The database selects users from a MySQL Table. The users have a nickname and a user_status.

The first version I wrote ordered the Users as followed:

$sql = $sql . " ORDER BY user_status, nickname ASC";

So now the clan Leaders wish that the active Members show up first on that list. The problem with that is that there are user_status such as "abgelehnt" which means user refused in German.

And that's where the Trouble starts. "abgelehnt" shows up higher than "aktiv".

I am really thankful for any suggestions.

Possible duplicate of How to define a custom ORDER BY order in mySQL — Raunak Gupta
– Raunak Gupta, Commented May 8, 2017 at 14:54

CyberAbhay · Accepted Answer · 2017-05-08 14:31:28Z

1

You can try this one

$sql = " SELECT filed1, field2, field3 FROM tablename
ORDER BY FIELD(status, "active", "inactive", "canceled")";

Change name of priority values according yours

answered May 8, 2017 at 14:31

CyberAbhay

5346 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sebastian Over a year ago

Thank u so much. That was exactly the Reference I needed!

Collectives™ on Stack Overflow

SQL PHP Sort Results WordPress

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related