query

Hi to all, I'm working in a system where users can post projects. Other users will verify those projects. What I'm trying to do is once a user verify a project he/she cannot view it anymore, but I want to keep it available for the other users that haven't verified it. I have two tables project and user_verified. On project table I keep all the projects that users post. On user_verified I keep users who already verified for a project. These are the fields for user_vefified table project_id, username, verified Everytime a user verifies a project I insert a new record to the user_verified table. This the query, but it doesn't work. It selects the same record from the two tables. e.g. if the records exist twice on the user_verified table and one on the project table, it will display three records when I run the the following query: $sql = "SELECT project.project_id, project.project_name, project.project_desc FROM project, user_verified WHERE project.username <> user_verified.username AND project.username <> '$PHP_AUTH_USER' AND project.category='$category')"; any help is greatly apprecciate it Thanks in advance Nato