separate query result in different columns

Thread Solved

Join Date: Jun 2008
Posts: 40
Reputation: enim213 is an unknown quantity at this point 
Solved Threads: 2
enim213 enim213 is offline Offline
Light Poster

separate query result in different columns

 
0
  #1
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
Reply With Quote Quick reply to this message  
Join Date: Dec 2008
Posts: 19
Reputation: ashafaaiz is an unknown quantity at this point 
Solved Threads: 1
ashafaaiz ashafaaiz is offline Offline
Newbie Poster

Re: separate query result in different columns

 
0
  #2
Jan 8th, 2009
Originally Posted by enim213 View Post
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
Hi,
What are you exactly trying to say? Make it clear. Do you want to display table items in a column or what else?
Reply With Quote Quick reply to this message  
Join Date: Jun 2008
Posts: 40
Reputation: enim213 is an unknown quantity at this point 
Solved Threads: 2
enim213 enim213 is offline Offline
Light Poster

Re: separate query result in different columns

 
0
  #3
Jan 8th, 2009
hi guys..

i posted my thread without any further explanation or illustrations..

my problem is i have a query that fetch (like for example) 5 rows and i want a column with different data.

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

from query to be like..

(in front-end)
first data | second data | third data
---------------------------------------------
data1 | data2 | data3

like that..

guys really need any idea, opinions, suggestions.. if that problem has any solution.. whether from mysql coding or php.

thanks for the help
enim
Last edited by enim213; Jan 8th, 2009 at 2:48 am.
Reply With Quote Quick reply to this message  
Join Date: Jun 2008
Posts: 40
Reputation: enim213 is an unknown quantity at this point 
Solved Threads: 2
enim213 enim213 is offline Offline
Light Poster

Re: separate query result in different columns

 
0
  #4
Jan 8th, 2009
hey thank you for the repply.. i have explained it from my second post
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 60
Reputation: pclfw is an unknown quantity at this point 
Solved Threads: 5
pclfw pclfw is offline Offline
Junior Poster in Training

Re: separate query result in different columns

 
0
  #5
Jan 9th, 2009
PHP will allow you to format the display of data in any format that you can think of.

Remember that you are taking data out of an array and placing it into holders, usually columnar but they can be a horizontal series
[d1 d2, d3 d4 d5 d6 d7 d8 d9]
just as easily.
Or a set of columns in a set of rows
[d1 d2 d3
d4 d5 d6
d7 d8 d9]

Using CSS they could be wandering independantly around the screen, or following the mouse. The actual placement is limited only by your imagination.
Reply With Quote Quick reply to this message  
Join Date: Jun 2008
Posts: 40
Reputation: enim213 is an unknown quantity at this point 
Solved Threads: 2
enim213 enim213 is offline Offline
Light Poster

Re: separate query result in different columns

 
0
  #6
Jan 9th, 2009
yeah! you got it. that's really what i did.,

thank you so much!.

enim
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC