title: Select Specific Rows in a Specific Order
body: <p>I have a script (in PHP) that goes through a bunch of different comparisons to generate an ordered array of entries in a table by the row id. Then I'm imploding the array into a string and using WHERE to select those specific rows, however I don't know how to order them in the same order as they were in the array.</p>
  
  <pre><code>$order_array = [50,49,42,52,53,54,51,48,47]
  $order_string = implode(',', $order_array);
  // echo $order_string returns '50,49,42,52,53,54,51,48,47'
  $sql_todo = "SELECT * FROM todo_list WHERE id IN ({$order_string})";
      if ($result_todo = mysqli_query($link, $sql_todo)) {
          while ($row_todo = mysqli_fetch_assoc($result_todo)) {
  </code></pre>
  
  <p>This successfully selects the desired rows, but they are not in the same order as the array. I know that I haven't told it to order them that way (so it didn't), but I don't know how to make it happen.</p>
  
  <p>Thanks for your time,</p>
  
  <p>Seth</p>