mysql - getting multiple tables data with php -

Suppose i have two tables ... i have received / added two table data order based on date Or according to ID!

It is so that if I have the date table1 id msg 2 it is msgd nowdate table2 id Date of comment 2 This comment is nowdate

So how can I get it in a query order by ID?

is the word you are looking for:

  ( Select from Table 1) Union (SELECT * FROM table2) ORDER ID