php help?

[ctn|chrisw]

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 :\

[fwgx]

$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
}

[pma]

you can ger more help from phpbuilder.com

[FesterHead]

This thread might help some.

[ctn|chrisw]

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