To make sure that other names are not interfered with, I would refine
what you're doing.
ie. "Theater Nuts" would become "ater Nuts, The"
obviously this is not acceptable...
so you would do something like this...
//does it begin with 'The '?
$name_start = substr($band_name, 0, 3)
if ($name_start=="The ")
{
//remove the word 'The' and following space from the beginning of the
string
$band_name = str_replace('The ', '', $band_name) ;
// add ', The ' to the end of the name
$band_name .= ", The";
}
> 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
