Result and Sort by Date

Any idea ?

You are making 3 separate request, that's why the order is not what you expect. I can think of 2 ways to fix this: 

1. Combine your 3 select query in a single one with UNION and add an order by for the results returned by all 3 selects.
Example: https://stackoverflow.com/questions/4374...nion-mysql

2. Combine the results of your 3 select in a single array, and sort this new array, maybe with usort, depending on the content: https://www.php.net/usort

CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
/*** NO support in private message - Use the forum! ***/