Using strlen and substr to Shorten DB Results

["Jami" <jami@jamisniche.com>]

I have a script that I am working on that pulls info from a database:

<-- Code -->
$getscname = mysql_query("SELECT * FROM subcat WHERE subcatid =
'$subcatid'") or die ("Couldn't get the info.<br>".mysql_error());
				
	while($sub_cat = mysql_fetch_array($getscname)){
		$subcat_id = $sub_cat['subcatid'];
		$subcat_name = $sub_cat['subcatname'];
					
		echo '<a
href="subcat.php?catid='.$catid.'&sc='.$subcat_id.'">'.$subcat_name.'</a
>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;';
	}
<-- Code -->

At the end of each link, a pipe is printed. I want to take the pipe off
of the last result, so that the page will prit out:

SubCat1  |  SubCat2  |  SubCat3

I've tried using strlen & substr to do this, but it cuts the pipe off of
all the results, not the last one. Any suggestions?

TIA.

--------
Jami
jami@jamisniche.com



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php