I am using PHP. I have following tables
1)Posts
|| post_id | post | date_posted ||
2) Photo
|| photo_id | photo | date_posted||
3) Video
|| video_id | video | video_link | date_posted||
I want to retrieve all rows present in all tables and order by date_posted.
I want to differentiate later after retrieving rows which one is video and which one is post
How can i do this?