Hello! Need to get 4 records from the database in descending order, except for 2.
I.e. get the data in the parameters in descending order. And if they 2 are not needed, they miss and instead of them to others, which matches the parameters.
I tried this:
$query = mysqli_query($db, "SELECT `name` FROM `users` WHERE `name` NOT IN (user_1, user_2) ORDER BY `balance` DESC, `id` DESC LIMIT 0, 4");
But finds nothing.