MySQL

separate columns records in different columns

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 40

Reputation: enim213 is an unknown quantity at this point

Solved Threads: 2

enim213

Offline

Light Poster

separate columns records in different columns

Jan 7th, 2009

hi All,

I want to ask if is there any possibility to separate column data in different columns using php code.. really dont know if i have solution in php or here in mysql..

any idea would be really appreciate
Thanx
enim

•

Join Date: Jul 2007

Posts: 1,175

Reputation: stephen84s is a glorious beacon of light

Solved Threads: 125

stephen84s stephen84s is offline

Offline

Veteran Poster

Re: separate columns records in different columns

Jan 8th, 2009

•

Originally Posted by enim213

f is there any possibility to separate column data in different columns using php code..

Would you care to elaborate on that with an example which illustrates what you exactly want ???

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."

"How to ask questions the smart way ?"

•

Join Date: Jun 2008

Posts: 40

Reputation: enim213 is an unknown quantity at this point

Solved Threads: 2

enim213

Offline

Light Poster

Re: separate columns records in different columns

Jan 8th, 2009

thank you for the reply.. i really apprecited it.,

the problem was

column 1
-----------
data1
data2
data3

from mysql query result would look like(in front end)

1stCol | 2ndCol | 3rdCol
--------------------------------
data1 | data2 | data3

that's it.

but i have solved it yesterday through php..
thank you so much for the reply.

enim