How can I query the database from a template?
 

Can someone please tell me which syntax i need to use to query the database from within a template?

I'd really appreciate it if you give me a very simple example

Thanks guys :)

What do you mean by 'within the template' ? All logic (ie: php code) needs to be done outside the template and call the the template after all the data is fetch.

oh ok, I didn't know that... thanks for the info

ok, so if i do the logic outside of the template, where exactly should I put the queries and how exactly would I use it within the template? is there and article that explains this?