Ok i'm having a little problem.
Using this sql query:
SELECT *
FROM `phpbb_posts_submissions` ps, `phpbb_posts_text` pt, `phpbb_posts` p, `phpbb_users` u
WHERE p.topic_id =2
AND u.user_id = p.poster_id
AND pt.post_id = p.post_id
ORDER BY p.post_time
LIMIT 0 , 30
the table phpbb_post_submissions is similar to phpbb_posts_text
The phpbb_posts has two types of posts
One which needs the phpbb_posts_text and one which needs the submissions.
If I add AND ps.post_id = p.post_id
It off course returns me 0 results.
Since ps.post_id currently never equals pt.post_id
I hope you guys understand this cause with my knowledge of databases and mysql I absolutely can't understand it.
