jwk811 Posted November 3, 2010 Share Posted November 3, 2010 i have a column with different data examples ex1 ex2 ex1 ex2 ex1 ex2 when i select it i want to group them by the name so they will come out like this.. ex1 ex1 ex1 ex2 ex2 ex2 i thought thats what "group by" was for but it only brought up one of the data each like this ex1 ex2 how can i do this? thanks! Quote Link to comment https://forums.phpfreaks.com/topic/217626-grouping-database-data/ Share on other sites More sharing options...
trq Posted November 3, 2010 Share Posted November 3, 2010 ORDER BY Quote Link to comment https://forums.phpfreaks.com/topic/217626-grouping-database-data/#findComment-1129791 Share on other sites More sharing options...
jwk811 Posted November 3, 2010 Author Share Posted November 3, 2010 oh ok i thought you could use order by and group by together. i wanted it to group but also in order by date. i can choose just one then if both isnt possible. thanks =] Quote Link to comment https://forums.phpfreaks.com/topic/217626-grouping-database-data/#findComment-1129795 Share on other sites More sharing options...
trq Posted November 3, 2010 Share Posted November 3, 2010 You can use both together, but I don't think it will get you the result your looking for. Maybe if you explain exactly what data you want retrieved and in what order. Quote Link to comment https://forums.phpfreaks.com/topic/217626-grouping-database-data/#findComment-1129844 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.