I am now building my first joomla component.
I have 3 tables in it: __questions __resaults __display
I also need the Joomla user table:
__users
I have a single view: view.questions.html
this view gets data and also needs some database functions. It needs to:
- Get information from the user table.
- Get information from the resaults table
- Get information from the display table
- -SET- information to the reaults table
Now, I know Joomla is built with MVC architecture. This, I assume, means no dealing with database in views.
Where should I store the database hendling functions, and how can I call them in the front end?
The function dealing with questions is in the question view model, no problem, but what about the other tables? Should I put the functions dealing with them in the question model as well, the helper file, or make models for each other table, and call them from the question view? If i should make other models, how do I call them from the question view?
Thank you very much for your help!