Hi, i've looked around the forums but can't find anything to help me.

Basically i need to grab the following information from the database using JUST the product id.

So i'd have a php page set up somewhere and all you'd need to do is enter the product id and it would display the following information:

Customer Name
Street Name
Postcode
Telephone Number
Purchase Date
Order Total
Attribute information (Colour: blue)

I know all i need to do is select the data from the multiple tables using a join but i'm struggling to get this working.

All i need is the database query, everything else is set up.

Would anybody out there be able to help me out? I wouldn't mind paying somebody for their help.