hi again everyone...i have here an attach image of my problem.... items in year level came from my database...what i wanted is that their would be no repitition...is this possible? please help 
jhedonghae
0
Junior Poster
Recommended Answers
Jump to PostUse DISTINCT keyword inside you sql query statement (since you said these data come from database).
Jump to PostExmaple:
"SELECT DISTINCT column_name(s) FROM table_name"
All 5 Replies
Mitja Bonca
557
Nearly a Posting Maven
Use DISTINCT keyword inside you sql query statement (since you said these data come from database).
Mitja Bonca
557
Nearly a Posting Maven
Exmaple:
"SELECT DISTINCT column_name(s) FROM table_name"
jhedonghae
0
Junior Poster
thanks a lot.. 
one more thing about this other attach image...i don't know why Section 1 & 2 are place in the last it should be above section 3
Mitja Bonca
557
Nearly a Posting Maven
In sql SELECT statement use ORDERBY columnName
"SELECT DISTINCT column_name(s) FROM table_name ORDERBY columnName"
jhedonghae
0
Junior Poster
"select * from SetSched where YearLevel = '" & ComboBox1.Text & "' And Buildings = '" & ComboBox14.Text & "' And Sessions = '" & ComboBox13.Text & "' ORDERBY Sections ""
what's wrong with this?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.