i need a simple mysql query.
there are two tables. one is user (id, name) the other one is blocked (blocker, blocked)
i need a query that selects users from the user table that are NOT blocked by a certain user (whose id is stored in a session variable)
$query="SELECT user.user_username, user.user_id
LEFT JOIN (user ON [url removed, login to view] user.user_id
AND [url removed, login to view] '".$_SESSION['useris']."'"
but it didn't work. obviously:)