mysql any array sorting problem

Question

I have some users listed below in an order:

user1 user2 user3 user4 user5

This is just a simple list, sorted according to age.

Now a new user (user6) comes in, and according to the sorting, he fits after user 2, so the order becomes like:

user1 user2 user6 user3 user4 user5

Now I want to know at which position it is. For example it is on place3. How can i find its position when a new user comes in the list?? Please tell any general way? there is no any database etc, just a logic question.

@moustafa: Does this have anything to do with MySQL?

Mike
– Mike

2010-07-10 07:45:32 +00:00
Commented Jul 10, 2010 at 7:45 — Mike
– Mike, Commented Jul 10, 2010 at 7:45

Community · Accepted Answer · 2023-11-20 22:45:59Z

1

What does this have to do with MySQL?

Use array_search($myuser, $users);

See https://www.php.net/manual/en/function.array-search.php .

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Jul 10, 2010 at 7:41

Borealid

99.4k9 gold badges111 silver badges124 bronze badges

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

1 Comment

El Yobo Over a year ago

Possibly array_search($myuser, $users) + 1 in this case (he seems to want the index + 1).

Oleksandr Khomenko · Accepted Answer · 2010-07-10 08:01:17Z

1

May be something like this:

SELECT count(b.id)+1 row_pos
FROM users a, users b
WHERE
    a.name = 'user6'
    AND a.age > b.age

Thus it shows position of your row

edited Jul 10, 2010 at 8:01

answered Jul 10, 2010 at 7:55

Oleksandr Khomenko

113 bronze badges

Collectives™ on Stack Overflow

mysql any array sorting problem

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related