Unanswered: query with multiple links to one table
I've been working in Access for years and now need to move some Access queries to mysql/php...looked and looked but can't figure this out.
I have a table of people (tblPeople): personID, personFname, personLname
table with interests: intID, refTo, interestID, refBy, personID
when creating a page to view one person's interests I want to include their name, but I also need to show the refTo name and the refBy name...all of which can also be pulled from the people table.
so personID, refTo and refBy are all numbers that reference back to the tblPeople.personID
I can do this in Access ...but how do I do it in mySQL/php query?
Thanks for any time and attention this deserves. Maybe I just haven't found the best places to look for answers.
I concur with Rudy, it is highly likely that you'll be using the same SQL again (minus some MSAccess particulars). Where your learning will need to begin is with PHP. Unfortunately there is not point 'n click interface for this . Begin with php.net and look up "PHP MySQL" on google and you'll find LOTS of tutorials for various ways of doing what you need to do. Once you have a PHP prototype post it in the PHP section of this board and i'm sure someone will find the time to help you progress.