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? Quote Link to comment Share on other sites More sharing options...
discomatt Posted March 27, 2008 Share Posted March 27, 2008 SELECT DISTINCT `colname` Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
cyrixware Posted March 27, 2008 Author Share Posted March 27, 2008 Thanks guys! 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.