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

T

themasterrocker

Guest
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 a moderator:

exemption

New Member
Messages
66
Reaction score
0
Points
0
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
 

exemption

New Member
Messages
66
Reaction score
0
Points
0
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..
 
T

themasterrocker

Guest
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

New Member
Messages
66
Reaction score
0
Points
0
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:
T

themasterrocker

Guest
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
 

Attachments

  • SAm.jpg
    SAm.jpg
    143.1 KB · Views: 39
Last edited by a moderator:

xmakina

New Member
Messages
264
Reaction score
0
Points
0
You'll have to fill in the blanks and rename fields where appropriate but I think this is what you're after.

PHP:
<?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 :)
 
T

themasterrocker

Guest
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 a moderator:

exemption

New Member
Messages
66
Reaction score
0
Points
0
PHP:
 <?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
 
Top