Sort records by the order of IN clause

Question

I have this code to insert data into an array called $usersEmails:

while($get = mysqli_fetch_assoc($query_run)){
    $userOne = $get['UserOne'];
    $userTwo = $get['UserTwo'];
    if($userOne != $id){
        array_push($usersEmails, $userOne);
    }else if($userTwo != $id){
        array_push($usersEmails, $userTwo);
    }
}

Then I have made a query using this array:

$query = 'SELECT `Email` FROM `users` 
          WHERE `Id` IN ('.implode(',', array_map('intval', $usersEmails)).')';

This code generates results ordered by users.Id, but I want these IDs to be ordered in the same order as they appear in my array.

In other words, I want the IDs to be output from 0 --> end of array

It's really not clear what you're asking. You might want to try rephrasing the question. — Patrick Q, Jan 12 '16 at 17:04
you have `while($get = mysqli_fetch_assoc($query_run))` yet your query's variable is `$query`. Plus, is `$usersEmails` treated as an array? I've been staring at that for a while, and couldn't come up with anything. Echo/var_dump to see what's going in there or not, and how. — Funk Forty Niner, Jan 12 '16 at 17:07
you asked, you received (just not a magical answer). So, how about letting us know what's going on or not? I won't be keeping this tab open any much longer. — Funk Forty Niner, Jan 12 '16 at 17:12
@chris85 yes they are integers and I want to select all the ids in that array — AhmedEssamAE, Jan 12 '16 at 17:32
"select by the array of users table Id not by using my array id". What exactly do you mean by this? — Patrick Q, Jan 12 '16 at 17:34
guys look : `Where Id In($anyArray)` it search database and if result exist in array then it select it while i don't want that I want it to select the first index in my arrray then the second then the third and so on — AhmedEssamAE, Jan 12 '16 at 17:39
now the lowest not the highest i want to search by using my array element arrangement — AhmedEssamAE, Jan 12 '16 at 17:48
Something like [this](http://stackoverflow.com/questions/10940402/mysql-order-by-a-fixed-list)? — Patrick Q, Jan 12 '16 at 18:02

score 1 · Accepted Answer · answered Jan 12 '16 at 19:13

Add to your sql query order by and use field:

$query = 'select `Email`
          from `users` 
          where `Id` in (' . implode(',', array_map('intval', $usersEmails)) . ')
          order by field(`Id`, ' . implode(',', array_map('intval', $usersEmails)) . ')

Sort records by the order of IN clause

1 Answers1