maliary Posted May 2, 2009 Share Posted May 2, 2009 Hello, Am using MySQL 5.0 I have this query SELECT name FROM dbo.tablenames Which gives the following jimmy robert michael I would to display that column information in one row such as jimmy robert michael Quote Link to comment https://forums.phpfreaks.com/topic/156535-display-column-data-as-a-row/ Share on other sites More sharing options...
Yeodan Posted May 2, 2009 Share Posted May 2, 2009 http://www.w3schools.com/PHP/php_mysql_select.asp Quote Link to comment https://forums.phpfreaks.com/topic/156535-display-column-data-as-a-row/#findComment-824246 Share on other sites More sharing options...
maliary Posted May 2, 2009 Author Share Posted May 2, 2009 Thanks but am not using php. Quote Link to comment https://forums.phpfreaks.com/topic/156535-display-column-data-as-a-row/#findComment-824257 Share on other sites More sharing options...
premiso Posted May 2, 2009 Share Posted May 2, 2009 I do not think it is possible, but you might be able to accomplish it with a "view", but I am not sure how it would be setup. I would look into MySQL Views and see if you can figure it out through that. Quote Link to comment https://forums.phpfreaks.com/topic/156535-display-column-data-as-a-row/#findComment-824313 Share on other sites More sharing options...
fenway Posted May 4, 2009 Share Posted May 4, 2009 GROUP_CONCAT is your friend. Quote Link to comment https://forums.phpfreaks.com/topic/156535-display-column-data-as-a-row/#findComment-826100 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.