[PHP-DB] Using strlen and substr to Shorten DB Results

[Jami]

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
[EMAIL PROTECTED]



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

RE: [PHP-DB] Using strlen and substr to Shorten DB Results

[John W. Holmes]

 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?

Based on how you're building your string, you'll want to remove the last
25 characters from it to get rid of the last | and all of the nbsp;
characters. So, this should work:

$fixed_str = substr($old_str,0,-25);

Or, you could use a regular expression to match the last | and whatever
follows it up to the end of the string.

$fixed_str = preg_replace(/|[^|]*$/,,$old_str);

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



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