While loops and HTML templates

JPD

Well I did search and I found a guy with almost the same problem as me. I'm writing a forum script and I need to use a while loop within the HTML template, I'm not sure how to do that. I'm using FastTemplates (Article here: http://phpbuilder.com/columns/sascha19990316.php3) as my template engine. I'm not quite sure how to do this. I read somewhere that I could do the loop in the PHP then put it into the template, but I can't see how to do this? This is the loop I need to use.

$newpmresult = mysql_query("SELECT * FROM pm WHERE user_id = '$user' AND isnew = 'yes'") or die("MerpForum: Database error!");
while($newpm = mysql_fetch_assoc($newpmresult))
 {
        "<tr>
		<td class=\"newpm\">$</td>
		<td class=\"newpm\">$newpm[title]</td>
		<td class=\"newpm\">$newpm[author]</td>
		<td class=\"newpm\">$newpm[date]</td>
		</tr>			         

		";
 }

theelectricwiz

Hello. I only had a very quick look at the template script, but what you could to is get the while loop to write to a string and then send that string to the template ie

$tempstring = "";
while($newpm = mysql_fetch_assoc($newpmresult))
 {
        $tempstring .= "<tr>
		<td class=\"newpm\">$</td>
		<td class=\"newpm\">$newpm[title]</td>
		<td class=\"newpm\">$newpm[author]</td>
		<td class=\"newpm\">$newpm[date]</td>
		</tr>			         

		";
 }
$tpl->parse(PAGECONTENT, $tempstring);

The last line of this code supposedly writes the string to the PAGECONTENT, which is then included in the outputted html page (from http://phpbuilder.com/columns/sascha19990316.php3?page=2). Since I haven't really properly look the template script, this may not be the best way to do it, but it seems like it will work.