A cleaner option might be to do this before you get it to PHP at all, via your SQL query.
Check out the string functions available, there are a number of substring-style things available, string position etc. HTH Beau // -----Original Message----- // From: Ed Gorski [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 30 May 2002 12:09 AM // To: Jen Swofford; php-db@lists. php. net // Subject: Re: [PHP-DB] dropping one word from column entries // // // use: // // $name="Mouse Housing Products"; // $name=str_replace("Products","",$name); // // also the RTFM() function works too // // ed // // At 11:06 AM 5/29/2002 -0500, Jen Swofford wrote: // >I'm having a problem with this and suppose I'm looking for // a handout. :| // > // >I am displaying names of product categories. The names of // the categories // >are: // > // >Bird Cages // >Cat Toys // >Chinchilla Housing Products // >Dog Leashes // >Ferret Housing Products // >Mouse Housing Products // > // >What I want to do when displaying the names is to drop // "Products" whenever // >it appears. What I want do display on the page instead is: // > // >Bird Cages // >Cat Toys // >Chinchilla Housing // >Dog Leashes // >Ferret Housing // >Mouse Housing // > // >And no, changing the names of the categories in the // database is not an // >option. :) I'm completely missing the boat on this one... // any help? // > // >Jen Swofford // >[EMAIL PROTECTED] // > // > // > // > // >-- // >PHP Database Mailing List (http://www.php.net/) // >To unsubscribe, visit: http://www.php.net/unsub.php // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
