last in_array

[dakey]

Hello, i know there is probably a really simple answer for this, but have been playing around for ages now and can't manage to find the answer!!

All i want is so that the last "$row[name]" to be displayed does not include the "<br>" afterwards so that i don't have a stupid blank line on by screen!

<?php
$sql = "SELECT FROM #### WHERE id = $_SESSION[id]";
$result = hesk_dbQuery($sql) or hesk_error("");
while ($myuser2=dbFetchAssoc($result))
{
$sql_category = "SELECT FROM ####";
$result_category = dbQuery($sql_category) or hesk_error("");

$cat=substr($myuser2['categories'], 0, -1);
$myuser2['categories']=explode(",",$cat);
$mycategories = $myuser2['categories'];

while ($row=dbFetchAssoc($result_category))
{
if (in_array ($row[id],$mycategories)) {
print $row[name];
print "<br>";

}
}
} // End while
?>

[laserlight]

Here's one way, keeping a counter to determine when the last row is reached:

//assume $num_rows contains number of rows in result set
for ($i = 1; $row = dbFetchAssoc($result); $i++) {
	echo $row['name'];
	if ($i < $num_rows) {
		echo "<br />\n";
	}
}

Here's another, using [man]implode/man:

$array = array();
while ($row = dbFetchAssoc($result)) {
	$array[] = $row['name'];
}
echo implode("<br />\n", $array);