can i pass data from view to controller?

[eluser]GrahamDj28[/eluser]
Hi,

Glade to help.

Now to see if I understand correctly.

You have a table with users.
You have a table with posts which has the userId as reference column to user table.
You have a table with comments which has the userId as reference column to user table and postId as reference column to posts table.

Now are you sure that when a comment is added that the correct userId is being set? So the userId of the person placing the comment is set, and not the userId of the original post. No shame if this is the case. Easy mistake to make.

And for my updated solution, if the posts are NULL, you should also have comments as NULL. The query can't return comments if no posts are found. If that is the case the query you are running is not correct. Are you using the query i provided?

Maybe you can send me a sql dump of the tables in question.
I will then run some queries to see whats what.