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:
in words: just split each row in each colum and but it in the new table.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 |
|_____________________________|
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...
:confused:
THX a lot.
Petra.