Member Avatar for jhedonghae

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 526949_423643440983941_100000148652191_1891701_429384302_n

  • 2 Contributors
  • 5 Replies
  • 104 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by jhedonghae
Member Avatar for Mitja Bonca

Use DISTINCT keyword inside you sql query statement (since you said these data come from database).

Member Avatar for Mitja Bonca

Exmaple:

    "SELECT DISTINCT column_name(s) FROM table_name"
Member Avatar for jhedonghae

thanks a lot.. Untitled64 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

Member Avatar for Mitja Bonca

In sql SELECT statement use ORDERBY columnName

    "SELECT DISTINCT column_name(s) FROM table_name ORDERBY columnName"
Member Avatar for jhedonghae 
"select * from SetSched where YearLevel = '" & ComboBox1.Text & "' And Buildings = '" & ComboBox14.Text & "' And Sessions = '" & ComboBox13.Text & "' ORDERBY Sections ""

what's wrong with this?

Edited by jhedonghae
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.