Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => Mail

How to show data from different table in one view?

the mail() function

Moderators: macek, egami, gesf

How to show data from different table in one view?

Postby farooqipk » Fri Jun 08, 2012 3:19 am

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
Attachments
milestone.jpg
milestone.jpg (119.77 KiB) Viewed 338 times
farooqipk
New php-forum User
New php-forum User
 
Posts: 1
Joined: Tue Oct 18, 2011 11:23 am

Re: How to show data from different table in one view?

Postby johnj » Wed Jun 20, 2012 9:20 pm

merge the data from different tables to get it as one.
johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: How to show data from different table in one view?

Postby engrmudasirmalik » Wed Jun 27, 2012 9:59 pm

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.
User avatar
engrmudasirmalik
New php-forum User
New php-forum User
 
Posts: 14
Joined: Wed Jan 11, 2012 11:39 am
Location: Bahawalpur Pakistan


Return to PHP coding => Mail

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.