Code: Select all
Table: block_access
block_id | user_id | block_value
----------------------------------
1 | 134 | foo
2 | 634 | bar
3 | 284 | foobarCode: Select all
SELECT s.whatever
FROM `search` s,
LEFT JOIN `block_access` b ON b.user_id = s.user_id
WHERE b.block_value != '" . mysql_real_escape_string($_POST['search']) . "'
GROUP BY s.user_idBasically, I believe I am probably going about this in the wrong way but am not sure as to how to proceed and would be thankfull for someone much wiser than me on this topic to point me in the right direction. I hope you were unable to understand my problem, I am not sure how I can explain it better.