Click here to Skip to main content
15,885,309 members
Search within:


Read column by column in PHP MySQL
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
PHP
MySQL
Hi all,

Say I have a data set select through a select query with multiple columns and rows. Rather access row by row I want to access column by column and manipulate data. How can I do that, any comments?

Thanks in advance.
Posted
Add a Solution
Comments
ZurdoDev 14-Feb-13 10:01am    
My comment would be why? Can you explain more?
CodingLover 14-Feb-13 10:32am    
Because, each column I want to arrange in rows.
ZurdoDev 14-Feb-13 10:34am    
Microsoft SQL has a PIVOT feature. Maybe that is what you want and maybe MySQL has a similar feature?
Rai Pawan 14-Feb-13 23:43pm    
Please check whether group_concat fulfills your requirement. have a look at http://www.mysqlperformanceblog.com/2006/09/04/group_concat-useful-group-by-extension/ and http://www.artfulsoftware.com/infotree/qrytip.php?id=78
- pawan

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to append mysql record column when it is NULL by default?
How to put the SQL column data into PHP variable?
How to read columns of a txt file in Python ?
In mysql want to plus one row from first column and secound columns one row
How to fetch data with same id in a row but different value in another column and display one month into table in PHP mysql
How to use a PHP variable as a column name in select query in MYSQL?
Php and MYSQL typing % in a search field is getting all results from the table
How to sum columns that is in SQL, to table that use PHP
Mysql:create table con PHP now table
How to look for a constant value by posting the column name in PHP mysql?

Advertise
Privacy
Cookies
Terms of Use
Last Updated 14 Feb 2013
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900