How to show data from different table in one view?

[farooqipk]

Hi guys,

I'm junior in PHP Development and I'm facing one of the issue. Please guys give me related suggestion.
Actually I've one system in which one project and we've divided in many sub-tasks. So I've made two table for that one for project and other one for milestone.

Now there are a few milestone(tasks) in one project and i want to show from database in the following layout:

e.g.

1. http://www.alltimeprint.com
Milestone for http://www.alltimeprint.com
mile-title create-date completion-date
1. forum posting 8 june, 2012 25 aug, 2015
2. blog commening 5 june, 2012 31 July, 2013
2. http://www.xyz.com
Milestone for http://www.xyz.com
mile-title create-date completion-date
1. forum posting 8 june, 2012 25 aug, 2015
2. blog commening 5 june, 2012 31 July, 2013

How and which query will be apply for the above layout. if the layout is not come proper please check the attachment file.

Thanks,

Best Regards,
Kashif

[johnj]

merge the data from different tables to get it as one.

[engrmudasirmalik]

You can stick yourself to joins. Using joins you can show data from different tables or if you have some expertise of OOP then define and module and use whenever you wanted to show data from different tables. Well i do use modules for this.