sort rows by a custom array

Question

Is it possible to sort rows by a custom array of ids given from another table or somehow.

$str = "5,2,3,6,911,18,118,65,985,15...";  

$arr = explode(',', $str);

function get_titles($status){
    global $db;
    $sql = "select * from arts where status = :astatus order by " . $arr . " asc";
    $st = $db->prepare($sql);
    $st->execute([":astatus" => $status]);
    ...
}

@Sean, both answers on your link are about sort by field. I have no a field as sort criteria, but an external array. — user7461846
– user7461846, Commented Dec 29, 2018 at 5:24
the field is what to order by. Your array is the additional values. ie. ... ORDER BY field(id, ". $str .") ... — Sean
– Sean, Commented Dec 29, 2018 at 5:30

Blaztix · Accepted Answer · 2018-12-29 14:37:19Z

0

If you want order by custom id order...

# $str = "5,2,3,6,911,18,118,65,985,15...";
# Values separated by comma
# It can be from array
#     $str = implode(",",[5,2,3,6,911,18,118,65,985,15])

$str = "5,2,3,6,911,18,118,65,985,15";  

function get_titles($status,$arr){
    global $db;
    $sql = "SELECT * FROM arts WHERE status = :astatus ORDER BY FIELD(id,".$arr .") ASC";
    $st = $db->prepare($sql);
    $st->execute([":astatus" => $status]);
    ...
}

get_titles($status,$str)

edited Dec 29, 2018 at 14:37

answered Dec 29, 2018 at 13:06

Blaztix

1,3161 gold badge21 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

sort rows by a custom array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related