I Have a query pulling and combining two tables together into one set of data. However, it is pulling all 12 from the one table. I was wondering how I could modify my present query, to get only where the userparts.owner is a person, and limit it to pull only the first 4 it comes from.
I've tried patching in LIMIT 4 and a check to make sure the userparts.owner is the person it needs to, but it doesn't work.
Edit: Guess I should've played around some more with it. I got it working.
Code:
"SELECT * FROM medaparts LEFT JOIN userparts ON medaparts.id = userparts.medapart_id;
I've tried patching in LIMIT 4 and a check to make sure the userparts.owner is the person it needs to, but it doesn't work.
Edit: Guess I should've played around some more with it. I got it working.
Last edited: