/    Sign up×
Community /Pin to ProfileBookmark

Problem with combo box with MySQL data

I have a problem related combo boxes.

  • 1. My combo’s results are taken from MySQL database. In the database I have a lot of data (my columns are “Name”, “Surname”) and of course it happens so that the Names or Surnames are repeated. Like Robert De Niro, Robert Burns, Robert Giraud, Robert McAlpine etc… So in my combo box I read the Names from the combo box but don’t want to have many Roberts – I want only one (so that the data were not repeated in the list).
  • to post a comment
    PHP

    1 Comments(s)

    Copy linkTweet thisAlerts:
    @Phill_PaffordMay 16.2008 — GROUP BY in your SQL query
    ×

    Success!

    Help @harevik85 spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 BETA 5.18,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...