I'm trying to retrieve the records in the order I think they were accessed.
My code is as follows:
Data to be searched:
$to_check="Yes_ij_affirmation', ',_cm', 'there_px_ex', 'is_vbz_1', '._fs";
Select statement:
$sql = "SELECT wd, wd_ps2, rt1, rt4, definition FROM august_2022 WHERE wd_ps2 IN ($to_check) order by ".$to_check."";
The result is (I put it in a list to make it easier to see the comparison to the original result):
I'm not sure if what I'm trying to do is possible, but suggestions are welcome.
WW
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
You need to add quotes in the code
And the select statement should look like this:
You need to add quotes at the beginning and end of
$to_check.You can then use the
FIELD()function to sort by position in the list.$to_check="'Yes_ij_affirmation', ',_cm', 'there_px_ex', 'is_vbz_1', '._fs'"; $sql = "SELECT wd, wd_ps2, rt1, rt4, definition FROM august_2022 WHERE wd_ps2 IN ($to_check) order by FIELD(wd_ps2, $to_check)"