[SOLVED] eregi help please (sorting issue)

[Bhaal]

This is just dumb 'cause it should be "easy".

 

Got a field holding 'artist name' (in an array) so when looped it prints:

 

Joe Smith

The Nube Koders

Henry Lee

Lisa Jones

The Idiots

... (etc.)

 

When sorting, the record "The Nube Koders" gets put in the "T" section obviously.

 

So I need to take the string "The" and place it after the actual name (with a comma) so it prints:

 

Nube Koders, The

 

Pretty sure eregi will work for this (eregi not ereg since some of the names are all caps).  But nothing I try is working.

 

After much consternation:

 

$artName = eregi ("(.+),( the)", $row['artistName'], $regs) ? $regs[1].", ".$regs[2] : $row['artistName'];

 

Doesn't work at all though.  No surprise there.

 

Any hints?

 

Thanks...

 

 

 

[Brian W]

This is a great tutorial on using regex

http://www.webcheatsheet.com/php/regular_expressions.php

 

best of luck... i hate regex but love it oh so much

[Bhaal]

For me, it's more of a hate-hate relationship.

[Bhaal]

Got it.  But of course now there's another problem: re-sorting the results.

 

I'll ask about this in another thread.