can i pass data from view to controller?

[eluser]GrahamDj28[/eluser]
Hi,

Glade to here it's all working now.

If you use this construction, then you can change the comments query to this:

Code:

SELECT c.date, c.comment,
u.picture,
u.name AS ownerOfComment
FROM comments AS c
LEFT JOIN users AS u ON u.id = c.userId
WHERE c.postId = ?
ORDER BY c.date ASC

As the query is now, you can select posts and their comments all at once.