got tricked here..need help to this wierd problem

[smilesmita]

i had huge xml string...got it parsed and converted into an flat array which looks like this:

$data2=array(

[a_0]=>'test'
[b_1]=>'test1'
[c_2]=>'test3'
[a_1]=>'test4'
[c_4]=>'test5'

)

did preg_replace on $data2 as $k=>$v
and now got it to be like this

$data3=array(

[a]=>'test'
=>'test1'
[c]=>'test3'
[a]=>'test4'
[c]=>'test5'

)
here i got tricked...because now when i give my insert statement it looks like this:
insert into table (a,b,c,a,c) Values('test,'test1','test3','test4','test5');

becaues you cannot specify a columname more than once in the sql query...
any idea how i could resolve this?may be if i could rename the second occurence of same name..that would solve it...

[Piranha]

The thing you want to do is breaking 1st normal rule. Read up on database normalization to understand why this is wrong and suggestions what to do about it. There is a good explanation at phpbuilder.com in articles.

[NogDog]

I'm confused. You say you do this:

$data3=array(

[a]=>'test'
=>'test1'
[c]=>'test3'
[a]=>'test4'
[c]=>'test5'

)

But, if you run this....

<?php
$data3=array(
   'a'=>'test',
   'b'=>'test1',
   'c'=>'test3',
   'a'=>'test4',
   'c'=>'test5'
);
printf("<pre>%s</pre>", print_r($data3, 1));

...you only have 3 array elements (as I would have expected):

Array
(
    [a] => test4
    [b] => test1
    [c] => test5
)