Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Jan 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Song Request System

    Hey all. I'm new to MySQL and have been racking my brains at this for hours, studying the MySQL documentation, etc, and have given up.

    All I want is some form of PHP/MySQL integration on my website that allows visitors to Reuqest Songs, and my DJ's be able to view all the reuqests in a page.

    It'd just involve adding values to a database (song name and song title) then getting a page to query them out and display them again.

    Would someone be so kind to write me a very very basic script that will do what I require?

    Regards,
    John.

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    How much are you willing to pay?

    If you aren't willing to pay then how much effort have you spent trying to find this?

    The albums and artists link in my signature might help you, but might not exactly be what you are looking for.

    You should at least look for a tutorial, so you understand putting values into and retrieving them from, a database.

  • #3
    New to the CF scene
    Join Date
    Jan 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the help. That will most definetely be useful.

    One thing, though, say I have created the two tables (songname and songartist), and it displays them, something like this:

    Song Artist
    Nirvana

    Song Name
    Smells Like Teen Spirit

    ..When the DJ looks at the list and plays a song that's been requested - how would I go about coding it so the DJ can simply click a 'Delete' button and delete that request from the database?
    Last edited by JohnRogers; 01-20-2007 at 02:23 PM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •