CSV to XHTML List

[mrpunkin]

Hello everyone. I am looking for a quick way to code a script that will take a comma seperated flat file and convert it to an XHTML unordered list.

What I am looking to do is for each row the first item would be a link for the second item. The second and third items would be encased in list item <li> tags and the entire row would be enclosed within <ul> tags. The order though of items would be the third item first in the list. This way something like

blah.com, blah, Vancouver
test.com, test, Portland

would output to

<ul>
<li>Vancouver</li>
<li><a href="blah.com">blah</a></li>
</ul>

<ul>
<li>Portland</li>
<li><a href="test.com">test</a></li>
</ul>

[kburger]

For each line in the file...

list ($href, $text, $city) = split(",", $line);
$text = trim($text);
$city = trim($city);
echo "<ul>\n<li>$city</li>\n<li><a href=\"$href\">$text</a></li>\n</ul>\n\n";