Winamp & Shoutcast Forums

Winamp & Shoutcast Forums (http://forums.winamp.com/index.php)

- General Discussions (http://forums.winamp.com/forumdisplay.php?f=1)

- - php help? (http://forums.winamp.com/showthread.php?t=138189)

Im trying to make it so I can submit using the dosomething plugin for winamp, the current playing song, artist, and album that Im listening to. I got a script that submits the song and it works

PHP Code:


		
			
<?php

      require_once('config.php');

      mysql_connect( localhost, chrisw, $password);

      mysql_select_db(chrisw_at);

      mysql_query("Update $table set artist = '".$_GET["artist"]."', title = '".$_GET["title"]."', album = '".$_GET["album"]."' WHERE name = '$_GET[name]'  ");

?>

but now im stumped to how to get it out of the db so that it will select from the where the name = song and will output it like
Artist: current artist's name
Title: Current song's title
Album: Current Album.
Does anyone have any idea cause Im stumped :\

$query = "SELECT * from $table WHERE name = $song";
$result = mysql_query($query);
$num = mysql_affected rows();

if ($num == 0) {
echo "Artist: $result[0]";
echo "Song: $result[1]";
echo "Album: $result[2]";

} else {
do something else
}

you can ger more help from phpbuilder.com

This thread might help some.

I got it a day or two ago :) thanks
http://www.chrisw.us/np/w00t.php :D (b00n wrote the code for t3h bottom)