how to make a full PHP and Mysql enabled page

[cellarius]

You need to take the time and try to understand what happens in the code.

1. You can not use echo, as Lynne already told you. That's what makes the results show up on top of the pages. You need to save the output of the loop into a variable, and that variable needs to be registered for use in your template. Replace echo with

PHP Code:

$output = 
// or, since we're in a loop,
$output .= 


2. Get your php code in order. There is a good cause for the comment "Your custom code goes here". Why don't you put your custom code there, but somewhere above? That's all messy!

3. There's no sense in wildly registering variables like $query, $row and $result in the middle of nowhere. Those three variables are only used in your php code, so there is no need to register them. Registering variables is for passing variables from the php code to the template. This happens under the comment "Now your template is being rendered." Add a line like this

PHP Code:

$templater->register('output', $output); 


where some other variables are being registered already and call it in the template using

{vb:raw output}