luminous Posted June 3, 2010 Share Posted June 3, 2010 I know you can use group_concat to do this, however, is it possible to group the values from a column into seperate row values instead of just a single row value containing all the data? Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted June 3, 2010 Share Posted June 3, 2010 ORDER BY the_column will cause rows having the same value in the column to be together in the result set. You then detect when the value changes (a new 'group' starts) in your presentation code that is processing and outputting the data. Quote Link to comment 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.