When you add the data //does it begin with 'The '? $name_start = substr($band_name, 0, 2)
if ($name_start=="The") { //remove the word 'The' and following space from the beginning of the string str_replace('The ', '', $band_name) ; //add ', The 'to the end of the name $band_name=$band_name.', The'; } You might want something more sophisticated if The with a capital is found in the middle of names, but hope this is a start Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Jonathan Underfoot [mailto:[EMAIL PROTECTED]] > Sent: 24 February 2002 18:36 > To: [PHP-DB] > Subject: [PHP-DB] "The" Debacle > > > I'm putting together a table with bands, and I have a slight > problem. Well it not really a problem as much as I'd like some > input from more seasoned professionals. Certain band names begin > with "The" but when listing them it would be of great advantge to > me to remove the "the." Has anyone else faced this dilemma? I > was thinking that when inputting and editing band names that I > could just scripot a new column with the comma in place. I > suppose librarys have this difficulty as well. So what is it? > > Column 1 - "The Distillers" > Column 2 - "Distillers, The" > > Or a bit of PHP programming every time I list them (seems more difficult.) > > Either way, does anyone have the propper PHP function I should use? > > Thanks much... > > -Jonathan > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php