How to add a mysql query into a view

[kratzi]

Hi I would like to add a mysql query into the view productdetails and then echo the result within a div. The query should of course get data from the mysql database which is part of the installation.

My question is here if I need to connect to the database form the view by entering the database details or if there is any command how I could avoid entering the database details at this stage.

Thank you

J 3.5.0 V; 3.0.14

[GJC Web Design]

https://docs.joomla.org/Selecting_data_using_JDatabase

you can use anywhere within Joomla