Cant find an example of what I am trying to do online. Check this if you have time drop some advice. I am new to php and mysql brand new…
I am trying to get results from a third table (projects) while checking others for a match. Heres how I am going about it-
Heres my tables
**users**
---------------------------------------
userID userType userName userPass
**userInfo**
---------------------------------------
userInfoID userID projectID
**projects**
---------------------------------------
projectID subjectID title description
I am trying to get all the information from projects but only where userID and projectID match the corresponding from userInfo. The userID is matched to sessionID and projectID to projects.projectID
Does this make sense or am I doing this way wrong? This is my first time playing with db. How can I do that query?