STRCHR help required

[up_the_junction]

Hi all,

I have a database full of names in the 'Forename Surname' format.

Now what I need to do is ignore the forename and space in order that I may return the surnames in alphabetical order.

I understand that the STRCHR function is the one I'm looking for - can anyone point me towards an existing script or walkthrough for such a problem?

Thanks in advance for your help.

[TheDefender]

$namevariable = "Joe Blow";
$thename = explode(" ", $namevariable);
echo $thename[1];

// Output:
// Blow

This can get a bit tricky if the name is Joe Bob Blow (where Joe Bob is the first name) because of the extra space. In that case, you would have to count the variables, and loop through them and pull just the last variable out, but it can be done as well.

I am not sure if you can use a space value in strchr, but either way, I think you will be facing the same type of issue. I am not 100% certain of how to do this using strchr, because I never tried. Explode has always worked for me.

[edit]
Oh, to sort them, you would then take your variables and load them into an array, and just use the sort() function to arrange the date in the array. (or rsort() to arrange them in reverse.)
[/edit]

[up_the_junction]

TD: many thanks for your help. I'll give it a go.