[Strictn9ne]

alright i am not to smart when it comes to coding so please if anyone has the spair time to help me complete this script i will be majorly appreciated and i cant offer much but if you have a link or banner i will display that **** for free for life not a major thing or anything but its extra advertising hehe

okay heres what i need done

Code:

<? 
$i=0; 
require("config.php"); 
$sql=mysql_query("SELECT name,count(name) as cnt FROM requestlist WHERE name!='' GROUP BY name ORDER BY cnt DESC LIMIT 705"); 
while($data=mysql_fetch_object($sql)) 
{ 
   $i++; 
    echo "<font face=tahoma size=1 color=#c0c0c0>".$i."<font color=#c0c0c0>) "; 
    echo "<font face=tahoma size=1 color=#c0c0c0>".$data->name." (<font color=#c0c0c0>".$data->cnt." <font color=#c0c0c0>requests) <br>"; 
} 
?>

right now the above code is grabbing the top requests made from the radio

now thats cool and all but i need to do my own little addition

this is what i need to achieve and all that is involved.

first i need to grab a single name from the requestlist table were gonna go with example name *ted*

now i want to first have the script post

Ted then a line break
and then i need the script to grab teds songs he requested. now this is where its confusing to me in the request table Ted's requests become a songid now i need to call them song id's that match the name ted

so

Ted
123432
23342
34232
32
1213
12113

and so on

now this is where its even more tricky
i need to convert the songid's to be converted instead of displaying as numbers it needs to then take the songid number and grab the songid number from another table called songlists

now in that table the id is now just called id instead of song id
so it will have to grab songid from requestlist and then convert that id to grab from the songlist id table. now that we got that info. we need to echo the song information. so in the songlist table there the id of the song then in that table theres also artist and song so the code needs to take the id and use the artist and song info from that id and echo just the name of the artist and song.

now to go back to the beginning this all has to be done so when it grabs the requesters name it just shows that requester and then under his name it would dispaly the songs one line after another till the requester didnt have no more.


now to spice it up a little more. i would want to achieve it so if the requester requested the same song three times or something it would not show that and instead just show that song and ( 3 times ) next to it

Now to spice this up even more i would want this to be able to start the grab by using a members name from the actual site

[Strictn9ne]

Code:

TABLE `requestlist` (
  `ID` mediumint(9) NOT NULL auto_increment,
  `songID` mediumint(9) NOT NULL default '0',
  `t_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `host` varchar(255) NOT NULL default '',
  `msg` text,
  `name` varchar(255) NOT NULL default '',
  `code` mediumint(9) NOT NULL default '0',
  `ETA` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` enum('played','ignored','pending','new') NOT NULL default 'new',
  PRIMARY KEY  (`ID`),
  KEY `t_stamp` (`t_stamp`)
) TYPE=MyISAM AUTO_INCREMENT=302 ;

theres the table for request list

Code:

TABLE `songlist` (
  `ID` mediumint(9) NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL default '',
  `diskID` mediumint(9) NOT NULL default '0',
  `flags` varchar(10) NOT NULL default 'NNNNNNNNNN',
  `songtype` char(1) NOT NULL default 'S',
  `status` tinyint(4) NOT NULL default '0',
  `weight` float NOT NULL default '50',
  `balance` float NOT NULL default '0',
  `date_added` datetime default NULL,
  `date_played` datetime default NULL,
  `date_artist_played` datetime default '2002-01-01 00:00:01',
  `date_album_played` datetime default '2002-01-01 00:00:01',
  `date_title_played` datetime default '2002-01-01 00:00:01',
  `duration` mediumint(9) NOT NULL default '0',
  `artist` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `album` varchar(255) NOT NULL default '',
    PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  UNIQUE KEY `filename` (`filename`),
  KEY `date_played` (`date_played`),
  KEY `date_artist_played` (`date_artist_played`),
  KEY `date_album_played` (`date_album_played`)
) TYPE=MyISAM AUTO_INCREMENT=75822 ;

theres the songlist table


now in the above post i said i needed to grab the artist and song but its actually artist title from the second table

so theres the two tables were working with and need to call from.
first one wuill grab the requests. then second one has the song information in it. so got to grab the name and songid from the first. and convert that info to grab the id from the second table and then echo

requester name
then there songs they requested.

[Strictn9ne]

is this really hard ? to achieve

[Strictn9ne]

Originally Posted by Strictn9ne

is this really hard ? to achieve

cant even get a reply like this is not possible or this is very hard to achieve or i wouldnt have a clue come on people at least point me the right way to start at least

[Kevinmiam]

PM Me, I think it can be done.