I have a table in which i need to sort the column names.
NOT sort by column names.....sort the COLUMN NAMES.
since it is easy to sort the records.....is there any way by which you can convert column into rows and rows into columns.
prasu
1
Newbie Poster
Recommended Answers
Jump to PostTo the best of my knowledge you cannot do this in SQL or MySQL, for that matter.
If you have access to PHP, you can read all column names in an array with mysql_field_name() and then sort and traverse the array.
Also have a look into the INFORMATION_SCHEMA …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.