MYSQL Query and TPL file

Hi ,

I have a PHP file "query.php" with mysql query in it which fetch records from a table , My site using Smarty templates "TPL" files , now i want to show records on site at left side which is left.tpl.

How can i get output on my site

Thanks
Usman

 

Assign the mysql result to and display it in the tpl file. Read the SMARTY crash course for more in depth info: http://www.smarty.net/crashcourse.php

 

or alternatively you can put the query inside left.tpl and enclose it inside {PHP}{/PHP} tags

 

That kind of defeats the benefit of separating your business logic from layout formatting code.

The proper way to do it, is assign the value in the PHP and then display the tpl file (where you print the assigned value).

 

yep, i dont really say, its a better way of doing it, if in any case he doesnt have any access to the source files ex: they are encrypted, then the OP could do it this way.