cyrixware Posted March 27, 2008 Share Posted March 27, 2008 Hi guys i wonder how to create a good query for this. I have this field: -------- | row_id | tbl_grade | ----------------- 001 grade 1 002 grade 2 003 grade 1 004 grade 1 005 grade 3 ----------------------------------------------- suposing i want to display this tbl_field using combo box or menu. i display this all but the problem is the display for the grade 1 is multiple. ex. grade 1 grade 1 grade 1 grade 2 grade 3 As you notice grade 1 displayed 3 times. how to display this one not to multiple the data. just incase in the filed grade 1 or etc is more than one it will display only the grade 1 alone not 3.. like this: ex grade 1 grade 2 grade 3 Any advice? Link to comment https://forums.phpfreaks.com/topic/98175-how-to-display-my-query/ Share on other sites More sharing options...
discomatt Posted March 27, 2008 Share Posted March 27, 2008 SELECT DISTINCT `colname` Link to comment https://forums.phpfreaks.com/topic/98175-how-to-display-my-query/#findComment-502270 Share on other sites More sharing options...
wildteen88 Posted March 27, 2008 Share Posted March 27, 2008 Use SELECT DISTINCT or GROUP BY field_name in your query Link to comment https://forums.phpfreaks.com/topic/98175-how-to-display-my-query/#findComment-502271 Share on other sites More sharing options...
cyrixware Posted March 27, 2008 Author Share Posted March 27, 2008 Thanks guys! Link to comment https://forums.phpfreaks.com/topic/98175-how-to-display-my-query/#findComment-502274 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.