Hi Gurus,

I am sgoogling and askTom for quite a while and I cannot find a good solution for my kind of problem.

I have a table with a couple of rows, sometimes more sometimes less, the table will be created from a csv file using sqlloader.

My problem is:
PHP Code:
from this table
__________________________________________________________________________________________
|       id    |    mon1        |    mon2    |    mon3    |    mon4    |    mon5    |
|
_________________________________________________________________________________________
|    1    |    1        |    2    |    5    |    2    |    1    |
|
_________________________________________________________________________________________
|    2    |    1        |    2    |    5    |    7    |    2    |
|
_________________________________________________________________________________________



--> 
all values should inserted into a new table: (these are routes from 1 point to another)

|
Aid  |   mob1_id   |   mob2_id       |
|
_____________________________|
1    |      1       |       2              |
______________________________|
1    |      2        |       5             |
_______________________________
1    |       5       |       2             |
|
_____________________________|
|  
1   |       2       |        1            |
|
_____________________________
in words: just split each row in each colum and but it in the new table.


I have already written a lot of code but nothing works..
Maybe one of you had a similar problem.

Help or a tipp would really be great...I am getting mad...


THX a lot.
Petra.