Templating with results from mysql database.

Okay, so I want to template information from my database. How can I do that?
For instance
// connect
// query
while($row = mysql_fetch_assoc($result)){

echo "<div id='main'>".$row['id']."</div>";
}
// etc
How can I template that? I would love to learn how. Thanks alot.

I do something similar:

<table>
<?php
while($row = mysql_fetch_assoc($query)){
?>
<tr>
<td><?php echo $row['result1']; ?></td>
</tr>
<?php
}
?>

I hate doing this whole echo "<table>" but its your choice :)

simplistic example of template replacement with loop & main template
this assumes that id , name,surname,comments are all database fields , not tested but should be close to working , you get the idea anyway ?

loop.tpl;

<div id='main'>{id} {name} {surname}</div>
<div id='main'>{comments}</div>


main.tpl

<h3>Installing linux on a dead badger</h3>
<b>Contributors</b>
{loop}
<b>etc</b>



<?
// connect
// query

/*or use file_get_contents if available*/
$tpl = implode( '' , file( './templates/loop.tpl' ) ) ;
$main_tpl = implode( '' , file( './templates/main.tpl' ) ) ;

$all = '' ;
while($row = mysql_fetch_assoc($result)){
$tmp = $tpl;
foreach( $row as $k=>$v ){
$tmp= str_replace( '{'.$k.'}' , $v , $tmp) ;
}
$all .= $tmp;
}

$main_tpl = str_replace( '{loop}' , $all , $main_tpl ) ;
?>

Thanks. :thumbsup: