Ideally, you would have 3 tables like so...
Projects(with one record per project)
projectID |ProjectName| etc...
1 my project
2 another project
Users(with one record per user)
userID| userName| etc...
123 Joe Blow
124 Mary Jane
In this example, Joe has verified my project only. Mary Jane has verified
"my project" and "another project".
Whether you use my database or yours, you will need to use SQL's JOIN syntax
to properly extract the information you are looking for. Read up on SQL and
JOIN types, (LEFT, INNER, OUTER etc.). They are tricky at first but well
worth it once you figure out what is going on. Or just repost, and someone
will help you out with it.
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:35 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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
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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php