Loop results as variables?

[Anon]

Heh, what a question. Consider this:

I'm "skinning" a site, so to speak using fopen()and str_replace() to remove psuedo-code from an html template and place db querry results in place. An example would be placed anywhere in the template would mean "banner goes here". It's basically so the look of the site can be changed on a whim.

All was looking good for a working prototype by 4:00 am (hehe) when I hit a small snag... links. I wanted to make a dynamic navigational system but I realized that the loops were breaking when I tried it.

So my question stands, How do I store the results of a loop as a variable? If there is only one result, hey, no problem.

If this turns out to be easy to solve, I appologize for asking. It's just not "clicking" for me.

(If you need to see the code, let me know via e-mail)

[Anon]

Well you would want to create one long string from the loop like

$str .= '<table width="500">';
while ($row = mysql_fetch_array($result)) {
$str .= sprintf('<tr><td><a href="http://%s">%s</a></td></tr>', $row["url"], $row["url"]);
}
$str .= '</table>';

Now you can place $str in where the anvigation goes.

[Anon]

Thanks Louie. I had pretty much the exact same thing (sans table code, it's not needed because of the template I'm using), except i was forgeting to put .=

Haha. Thanks again.