Jump to content

mysql query help please


appeland

Recommended Posts

Hello,
since our local IT department does not allow us to have mp3's on our
workstations at work I have written a few php scripts that upload and stream
mp3's directly out of a mysql DB. The scripts work great and the performance is
also fine since it runs in the LAN and the IT department can scan themselfs silly, they will not
find any mp3's :)

However, one function still makes me headaches.
I want to make a drop-down box for artist and genre (making the drop down box itself is not a problem)
If I now do a select to the genre or artist column of the DB I obviously get the same artists and genre as often as it's there.

I have googled myself to bits now and just cant find an answer to this or I just dont know
what to search for.

Is there a query like [b]"select <column> from <table> but only one of each"[/b] :) ?

Thanks & Regards,
Andi


Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.