Using strlen and substr to Shorten DB Results
| From: | Jami | Date: | Sun, 26 Jan 2003 22:07:39 +0000 |
| Subject: | Using strlen and substr to Shorten DB Results | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25151@lists.php.net to get a copy of this message | ||
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
> | ';
}
<-- 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