[SOLVED] Sorting query in order of id array

[unxposed]

I have a mysql query where I'm selecting modules using an array of module id's. These are already in the order which I'd like the rows ordered by, which isn't neccesserily logical (i.e. - could be 24, 2, 7, 1, 3, 15, 10). Buty I just have no idea what to put in the ORDER BY field.

 

$query = "SELECT * FROM modules WHERE mid IN ('".implode("', '", $mids)."') ORDER BY mid ?? ";

 

Many thanks!

[Barand]

$mids = array (24, 2, 7, 1, 3, 15, 10);
$midlist = join (', ', $mids);
$query = "SELECT * 
   FROM modules 
   WHERE mid IN ($midlist) 
   ORDER BY FIELD(mid, $midlist) ";

[unxposed]

Thanks this is awesome!