Re: [PHP] how to mix two arrays into one and sort it by date/time?

Problem solved by mysql query (I thought it would be more tough :) ) my_query(" (select order_transaction_no, order_date from order_table_1 where order_date >= '". $date_yesterday ."') union (select order_transaction_no, order_date from order_table_2 where order_date >= '"

[PHP] how to mix two arrays into one and sort it by date/time?

I have two tables with orders of different type of articles. order_table_1 order_table | order_transaction_no | order_date | ... 1 | 56982 | 2005-07-29 9:12:34 1 | 97163 | 2005-07-30 8:45:32 1 | 67452 | 2005-07-31 10:56:11 order_table_2 order_table | order_transaction_no | order_date | ... 2 | 36