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 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 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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.