This topic is locked

Display joined table values

6/2/2008 3:29:41 PM
PHPRunner General questions
K
kushaaal author

Hello,

I have created two tables and joined them
One table has Product and the other as orders.

Now when displaying the page, with each order value a separate table is shown with doubling of the product table values.
I wanted to display only one time the product details and below which the details of all order.

Can you let me know how to do that?

Regards,

J
Jane 6/4/2008
K
kushaaal author 6/8/2008

I could not understand if that is linked to what am I asking for.
Here is the information.

  1. A user has a profile table
  2. A user has a 'training' table
  3. A user has a 'past performance' table.
    Now I joined all of them to display at one page. The problem is a user can have multiple trainings and multiple 'past performance' values.
    I want to display only one time the Profile, and which should list all the trainings he had attended, and the all the past performances he had done in one view.
    Can you help me achieve that?

    Regards,

J
Jane 6/9/2008

Hi,
you can try to create report and join all tables in this report. Then select fields from Profile table on the Report: Group fields tab.

K
kushaaal author 6/14/2008

Jane,

Thanks for the help. I am not able to get to this.
Let me explain again. I have profile field with complete Bio- data, and then another table containing each profile training details.
When I join, them in condition where one profile has multiple training data, it display each training with duplicate profile fields.
I was looking for: One time visibility of Bi-data and beneath it having all the training the profile has attended and also to include Past performances, Past Placements e.t.c. so that in one view a profile can be read along with all mulitiple trainings, education attended e.t.c.
Hope I am able to put is clearly.
I did tried with report option, but it is no way near what I meant.
Regards,

Sergey Kornilov admin 6/14/2008

This is exactly what reports do. You can get all training and performance data grouped by profiles.
If this is not what you looking for send a screenshot that explains what you trying to achieve to support@xlinesoft.com.