php project plan (SQL PROBLEM)

i am making a project list with comments from users in PHP.

here are the tables:

current_projects
id project priotity due description active
1 blah 1 1/2 blah 1

users
id name
1 John Doe

comments
id user_id comment active project_id
1 1 blah 1 1


i want to list all comments to a specific project and show who says what

here my sql... but it wont work!


SELECT u.name, c.comment
FROM users u, comments c, current_projects p
WHERE u.id=c.user_id
AND c.project_id=p.id
AND c.active=1


it shows all comments on all projects

HELP!

thanks

sj

You need to add "AND p.id=X" (where X is a project id) in order to limit this to a single project.

THanks so much... I knew it, but i couldnt see it. What an amateur! :-)

s