+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: need someone to do me a mySQL table, for credits :D

  1. #1
    themasterrocker Guest

    need someone to do me a mySQL table, for credits :D

    Hey Guys,

    I'm a DJ on X10 radio.
    Can anyone design and send me a table i can put on my site to make my X10 radio playlist into a click playlist? So like you click a song you want to play and it requests it and sends me the request to SAM broadcaster.

    Thanks in advance

    --themasterrocker--aka--DJ SPOON--
    Edit:
    Anyone want to do it? Help a radio DJ out? Please!
    Last edited by themasterrocker; 09-28-2008 at 02:59 AM. Reason: Automerged Doublepost

  2. #2
    exemption is offline x10Hosting Member exemption is an unknown quantity at this point
    Join Date
    Sep 2008
    Posts
    66

    Re: need someone to do me a mySQL table, for credits :D

    Well it depends on what you need..

    Code:
    CREATE TABLE `cashxferlogs` (
      `song` int(11) NOT NULL auto_increment,
      `which` int(11) NOT NULL default '0',
      `what` int(11) NOT NULL default '0',
      `cxVALUE` int(11) NOT NULL default '0',
      `cxTIME` int(11) NOT NULL default '0',
      `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
      `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
      PRIMARY KEY  (`cxID`)
    ) ENGINE=MyISAM
    Need more information..but that is a basic table for a song list to list..so lol yea lemme know

  3. #3
    themasterrocker Guest

    Re: need someone to do me a mySQL table, for credits :D

    Well this is how my playlist looks at the moment. If you click this link http://www.helprunescape.net/X10radioplaylist.xml

  4. #4
    exemption is offline x10Hosting Member exemption is an unknown quantity at this point
    Join Date
    Sep 2008
    Posts
    66

    Re: need someone to do me a mySQL table, for credits :D

    Well...you could write a script so that you can insert songs direct from your shoutcast or w/e you use..
    Like a song upload..and then you create the custom playlist..
    But I am not sure of what you want..


    I program PHP..so if you need help lemme know!


  5. #5
    themasterrocker Guest

    Re: need someone to do me a mySQL table, for credits :D

    Basically when the someone goes on my playlist If they want a song, if they click it like a weblink it will tell them its been requested and send it to my broadcaster.

  6. #6
    exemption is offline x10Hosting Member exemption is an unknown quantity at this point
    Join Date
    Sep 2008
    Posts
    66

    Re: need someone to do me a mySQL table, for credits :D

    Well...
    Then your broadcaster had better be able to play multiple songs...
    Or you could do something like
    Code:
    <a href='listmotcrueone.php?listen=1'>Motley Crue~One</a>
    But if you were to have that you would have to have something like a plugin for the 'listmotcrueone.php' file
    Such as

    Code:
    <?php
    include "headerfile.php";
    print "<h3>Motley Crue~ONE</h3><br />
    <script type="text/javascript">
    Have the script for your plugin
    </script>";
    }
    $h-endpage()
    ?>
    Or you could just use a flash code..
    The simplest thing would just to have simple plug ins for your player..
    and when you wanted to broadcast..a pop up would occur..which is easy to program with javascript..
    Edit:
    If that is something you are looking for...
    If not specify more please
    Last edited by exemption; 09-28-2008 at 03:34 AM. Reason: Automerged Doublepost


    I program PHP..so if you need help lemme know!


  7. #7
    themasterrocker Guest

    Re: need someone to do me a mySQL table, for credits :D

    Well, i got told mySQL is the key by Woiwky. (old friend) and he's gone somewhere because he hasn't been on X10 in a while and hasn't been on msn in a while because he was going to do it. And my broadcaster is: SAM Broadcaster
    Attached Thumbnails Attached Thumbnails need someone to do me a mySQL table, for credits :D-sam.jpg  
    Last edited by themasterrocker; 09-28-2008 at 03:45 AM.

  8. #8
    xmakina's Avatar
    xmakina is offline x10 Lieutenant xmakina is an unknown quantity at this point
    Join Date
    May 2008
    Location
    England
    Posts
    265

    Re: need someone to do me a mySQL table, for credits :D

    You'll have to fill in the blanks and rename fields where appropriate but I think this is what you're after.

    PHP Code:
    <?php
    echo "<table>";
    echo 
    "<tr>";
    echo 
    "<th>Band</th><th>Song</th><th>etc...</th><th>Request</th>";

    $sql "SELECT * FROM Songs";
    $result mysql_query($sql);
    while(
    $row mysql_fetch_array($result){
    echo 
    "<tr>";
    echo 
    "<td>" $row['bandName'] . "</td>";
    echo 
    "<td>" $row['songName'] . "</td>";
    echo 
    "<td>etc</td>";
    echo 
    "<td><a href=\"request.php?songID=" $row['songID'] . "\">Request</a>";
    }
    ?>
    The request page takes songID in it's $_GET array so it can be used in a request.

    Hope this helps

  9. #9
    themasterrocker Guest

    Re: need someone to do me a mySQL table, for credits :D

    Ok, well... time to make a db however i still need the db created although i got someone working on it, need it done ASAP. I think hellsheep is going to help me when he comes back online. Also where does the PHP send the data of whats been requested?
    Last edited by themasterrocker; 09-28-2008 at 09:17 AM.

  10. #10
    xmakina's Avatar
    xmakina is offline x10 Lieutenant xmakina is an unknown quantity at this point
    Join Date
    May 2008
    Location
    England
    Posts
    265

    Re: need someone to do me a mySQL table, for credits :D

    To "request.php" as a GET rather than POST.

+ Reply to Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [PHP] MySQL and PHP
    By Bryon in forum Tutorials
    Replies: 43
    Last Post: 03-24-2011, 07:27 AM
  2. Replies: 14
    Last Post: 09-29-2008, 07:07 PM
  3. New Site-Suggestions?
    By mnoutside in forum Review My Site
    Replies: 9
    Last Post: 08-27-2008, 07:01 AM
  4. MysQL Query for Master table & child table
    By phpasks in forum Programming Help
    Replies: 8
    Last Post: 08-07-2008, 08:07 AM
  5. Table inside table
    By wizeman in forum Tutorials
    Replies: 4
    Last Post: 07-11-2005, 05:56 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
x10hosting free hosting for the masses
dedicated servers