[Solved] dont show hide post which user had hide that post

Question

Use it this way:

SELECT * FROM `user_post`
  WHERE `id` NOT IN (
    SELECT `post_id` FROM `hide_post`
      WHERE `user_id` = '{$userID}'
      AND `status` = 'hide'
  )

Here the {$userID} should be the current logged in User’s ID.

Accepted Answer

Use it this way:

SELECT * FROM `user_post`
  WHERE `id` NOT IN (
    SELECT `post_id` FROM `hide_post`
      WHERE `user_id` = '{$userID}'
      AND `status` = 'hide'
  )

Here the {$userID} should be the current logged in User’s ID.