how to add columns dynamically in straight table?

[Akina0929]

Hi,

  I have table that consist

Pid,  Pname

1      ,mango

2      ,coriander

3      ,pepper

if the pid again comes it needs to same columns beside like following

pid, pname,     pid,   pname

1   ,mango,       1    , banana

2   ,coriander

3   ,pepper        3    ,sapota

dynamically it needs to add columns to table if the same pid is comimg again and again . how can i achieve please help me.

[Peter_Cammaert]

Where will this end? Imagine you have a hundred products for each PID/CID. Do you think this is a good method to compare products?

[vishsaggi]

Who is Anji M? Is this your question or his? Just got confused.

[satheshreddy]

Hi Nagaraju,

this is anji M Post and am also same situation that's why am involved here instead of new post.

Regards

Sathsih

[satheshreddy]

Hi Peter,

No But i need to create columns Dynamically

can you suggest me on this how we can create Dynamically  Columns.

we have n no of rows how we can achieve.

Regards

Sathsih

[vishsaggi]

Ok, i am sorry, i am out of options here. The script i suggested will help you create the columns. However, if you need in front end, may be some one else should able to help.

[satheshreddy]

Hi Nagaraju,

Thanks for your support, will wait some other expert solutions.

Regards

Sathsih