Little Parsing help...

Hello, I am building a web Song DB. That will simple song chord charts in the DB. I would like the ability to do KEY changes for the different songs. I am looking for some direction on how to do this. This was my original thought but I am open if there is a better way. I defined a table called Chords (here is the mySQL Dump): DROP TABLE IF EXISTS Chords; CREATE TABLE Chords ( id int(11) NOT NULL auto_increment, original_note varchar(2) default NULL, up_note varchar(2) default NULL, down_note varchar(2) default NULL, flatted varchar(2) default NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; LOCK TABLES Chords WRITE; /*!40000 ALTER TABLE Chords DISABLE KEYS */; INSERT INTO Chords (id,original_note,up_note,down_note,flatted) VALUES (1,'A','A#','G#',NULL), (2,'A#','B','A','Bb'), (3,'B','C','A#',NULL), (4,'C','C#','B',NULL), (5,'C#','D','C','Db'), (6,'D','D#','C#',NULL), (7,'D#','E','D','Eb'), (8,'E','F','D#',NULL), (9,'F','F#','E',''), (10,'F#','G','F','Gb'), (11,'G','G#','F#',NULL), (12,'G#','A','G','Ab'); /*!40000 ALTER TABLE Chords ENABLE KEYS */; UNLOCK TABLES; --------------- now this is a sample of my Music Charts:

                 C     Dm7        Em

This is the first line of my song

         C/E      Em7            Dm7

and I know it can get real long

         Gm7          Am7

If you know I will say

                 G/B                    C

That it will help to ease the day What I was hoping for is to check patterns in the CHORD LINES. I realize I need to mark which lines do PHP will now which line to parse. I was thinking that the user would add a asterisk "*" at the beginning of the chord line like so:

*                C     Dm7        Em

This is the first line of my song

*         C/E      Em7            Dm7

and I know it can get real long

*         Gm7          Am7

If you know I will say

*                 G/B                    C

That it will help to ease the day Then have PHP look for occurrences in the lines that begin with an "*". So if I want to transpose up 1/2 step, it would look like this:

*                C#     D#m7        Fm

This is the first line of my song

*         C#/F      Fm7            D#m7

and I know it can get real long

*         G#m7          A#m7

If you know I will say

*                 G#/C                    C#

That it will help to ease the day So if I want to transpose up 1/2 step, it would look like this:

*                B     C#m7        D#m

This is the first line of my song

*         B/D#      D#m7            C#m7

and I know it can get real long

*         F#m7          G#m7

If you know I will say

*                 F#/A#                    B

That it will help to ease the day I guess the challenge would that once the value was changed, it would not get changed again it same process. Also, I need to make sure that EXACT Case is only changed. For example, there might be a chord like "Asus add 9" where I would not want the "a" of add9 to change. Any suggestions would be appreciated. Don Wieland