can i pass data from view to controller?

[eluser]GrahamDj28[/eluser]
Ok,

I have done some testing and here are me results.

I created the user and comment tables for the testing. The columns will not match your own, but it comes down to the same thing.


USER TABLE
id | username | name
------------------------------------
31 | GrahamDj | Martin Langenberg
------------------------------------
32 | Brian88 | Brian Forum User
------------------------------------
33 | RandomUser | Some Name Here
------------------------------------
34 | SomeUserName | This Is His Name


POSTS TABLE
id | body | date | userId
---------------------------------------------------
35 | this is a post | Monday, April 30th | 31
---------------------------------------------------
36 | yaaaa | Tuesday, May 1st | 32


COMMENT TABLE
id | userId | postId | date | comment
----------------------------------------------------------------------------------------
1 | 33 | 35 | 2012-05-02 22:46:55 | This is a response to post id 35
----------------------------------------------------------------------------------------
2 | 34 | 35 | 2012-05-02 22:46:55 | This is a second response to post id 35
----------------------------------------------------------------------------------------
3 | 33 | 36 | 2012-05-02 22:46:55 | This is a response to post id 36


THE QUERY

Code:

SELECT p.*, c.*,
up.username AS ownerOfPost,
uc.username AS ownerOfComment
FROM posts AS p
LEFT JOIN comment AS c ON c.postId = p.id
LEFT JOIN user AS up ON up.id = p.userId
LEFT JOIN user AS uc ON uc.id = c.userId

THE RESULT OF THE QUERY
Link to image

Before changing your code, update the query to match your table and column names and then run the query in phpmyadmin.

Good luck!