ricksum - 11:25 am on Jun 27, 2013 (gmt 0)
Sorry I wasn't very clear but #2 is what I want. Let me try to be a little clearer, I hope.
I have a string that contains a username which consists of a last name, first name (separated by a space and if the user has a mate that name will be separated by an &.
I know how to find the location of all the spaces (let's say the username is Hahn Jerry Don & Julia Fay). What I need are variables that contain Hahn as last, Jerry Don as Husband and Julia Fay as Mate.
I would prefer to use mysql to accomplish this but php would do.