I'm no SQL pro, but I have the following statement that works... but I want to add something else to it.
SELECT p.id,p.user,p.userid,p.cat,p.storecat,p.ismature,p.title,p.bigimage,p.height,p.width,u.location FROM pp_photos p, pp_users u WHERE p.approved=1 AND p.storecat=0 AND p.userid=u.userid...