The query as it is;
Code: Select all
SELECT *
FROM $forumzDB.forumz_posts p
JOIN $forumzDB.forumz_threads t ON (p.tid = t.tid)
JOIN $forumzDB.forumz_forums f ON (t.fid = f.fid)
WHERE p.time > ".$_COOKIEї'last_visit']."
AND f.level <= ".$user_propertiesї'status_id']."
AND f.type != 'lock'
AND p.uid != ".$user_propertiesї'uid']."
ORDER BY p.time ASCSo Im confused how to incorporate that and the more I think about it the more I confuse myself, help