mysql UNION question

[[email protected]]

my query:

SELECT * FROM `table1` UNION ALL SELECT * FROM `table2` ORDER BY `date` desc

 

#1) when i am getting the data using mysql_fetch_array, how can i tell which table the row is from?

 

#2) how can i get everything to order by `date` desc? like right now, that does order it by date desc, except it does the 1st table 1st, the 2nd table 2nd.

[esukf]

Try:-

 

(SELECT 1 AS tableNo, id, name, date FROM `table1`) UNION ALL (SELECT 2 as tableNo, id, name, date FROM `table2`) order by tableNo ASC, date DESC;

You need to list out all the columns. SELECT * won't work.