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! 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 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 =] 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. Link to comment https://forums.phpfreaks.com/topic/217626-grouping-database-data/#findComment-1129844 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.