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

[themasterrocker]

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!

 

[exemption]

Well it depends on what you need..

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

 

[themasterrocker]

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

 

[exemption]

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..

 

[themasterrocker]

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.

 

[exemption]

Well...
Then your broadcaster had better be able to play multiple songs...
Or you could do something like

<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

<?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

 

[themasterrocker]

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

 

[xmakina]

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

<?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

 

[themasterrocker]

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?

 

[xmakina]

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

 

[exemption]

 <?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>"; 
} 
?>

Not bad...creates a table using sql injections..
Need to create a table..simple enough to do..
Make sure you have an insert table..to insert songs into your table..
SQL tables are easy to make

W3Schools
Live it, Learn It, Code it