Jump to content

Advanced MYSQL statements


sbsmith

Recommended Posts

Hello everybody,

 

I've been a full member of killer site uni for a few months now and I'm learning quite a lot due to the content provided in the killer site members area;

 

Presently I'm trying to develop a wordpress plugin and I've ran into a challenge that is has hurt my head for the last few days.

 

What I'm trying to accomplish is to create a separate view out of the three MySQL tables below so that my php application can loop through and display it on page.

 

I'm working on my localhost WAMP and working with MySQL via the terminal. I would really appreciate if some MYSQL experts here could help me resolve this problem,

 

I think it may be easier to show you the three tables I'm trying to join together in order to produce the view for my php application.

 

1. Here are My 3 tables below displayed in pic;

 

ad32c.jpg

 

 

2. Below is a pic of the table VIEW that I wish to produce from the 3 tables above .

 

5c864.jpg

 

 

3. Here is my msql file with the 3 tables so that you can easily dump it into your test database.

 

http://www.mediafire.com/?8uyia9dst2nblhi

 

Overview

I'm trying to create a table view that looks like what I provided above in ( no 2.)

from the three tables above in ( no 1.)

 

 

 

Really appreciate the help or any other ideas to produce the same result and look forward to contributing to

community.

 

regards,

Sheldon

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...