If end of file, Don't!

[zonkd]

Simple, it must be, but I don't know how ...

I want to say that at the EOF, don't add '|' to the page, please. (It's for the global nav. )

The code

$result = @("SELECT CONCAT('<li> <a href=\"', Link, '\">', Named, '</a> &nbsp; | &nbsp; </li>') AS gn FROM GlobalFront ORDER BY GlobID");
if (!$result) {
exit('<p>Error performing query: ' .
mysql_error() . '</p>'
);
}
while ($row = mysql_fetch_array($result)) {
echo $row['gn'];
}
echo '</ul>';

[konsu]

hello, may i suggest to not use database to generate html markup but do it in php code? this way you have a cleaner separation of data and their representation. and in php it is easier to check whether you need to output the pipe character or not.

[devinemke]

if you simply want a pipe ("|") separated list:

$result = mysql_query('SELECT Link, Named FROM GlobalFront ORDER BY GlobID') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	$array[] = '<a href="' . $row['Link'] . '">' . $row['Named'] . '</a>';
}
echo implode(' | ', $array);