Rating

[DoMiNaToR69]

i have problem with this code when i try to rate song popup window opens and suppose to show just rate code in that window but shows all my index.php any help appreciated. Thanx in advance.

/********** Rate Song Functions ***********/ 
    function rateSong() { 

    $song_id = addslashes($_GET['song']); 

    $query = "SELECT song.rating, song.num_rating, album.album_name as album_name, album.id as album_id, artist.id as artist_id, artist.name AS artist_name, song.song_name, song.id as song_id FROM song, album, artist WHERE album.id = song.album_id AND artist.id = song.artist_id AND song.id = '".$song_id."'"; 
    $result = mysql_query($query) or die(mysql_error()); 
    $row = mysql_fetch_assoc($result); 

    if( $_GET['save'] == 'yes' ) { 

        $rating = $_POST['rating'] + $row['rating']; 
        $num_rating = $row['num_rating']+1; 

        $query = "UPDATE song SET rating = '".$rating."', num_rating = '".$num_rating."' WHERE id = '".$row['song_id']."'"; 
        mysql_query($query); 
        print("<title>Rate this Song</title>"); 
        print("<p style='text-align: center'>Ratings for the song updated.<br><br>Thankyou for Rating this Song</p>\n"); 
        print("<p style='text-align: center'><input type='button' onClick='window.close()' value='Close Window' ></p>\n");         
    } else { 

        print("<form name='form' action='".$this->thisfile."?action=rate&song=".$row['song_id']."&save=yes' method='post'>\n"); 
        print("<table style='width: 100%; border: 0px;'>\n"); 
        print("<tr><td colspan='2'><b>Rate this Song</b></td></tr>\n"); 
        print("<tr><td>Song:</td><td>".$row['song_name']."</td></tr>\n"); 
        print("<tr><td>Artist:</td><td>".$row['artist_name']."</td></tr>\n"); 
        print("<tr><td>Album:</td><td>".$row['album_name']."</td></tr>\n"); 
        print("<tr><td style='text-align:right'><input type='radio' name='rating' value='1'></td><td><img src='images/1_s.gif' alt='1 star'> Bad</td></tr>\n"); 
        print("<tr><td style='text-align:right'><input type='radio' name='rating' value='2'></td><td><img src='images/2_s.gif' alt='2 stars'></td></tr>\n"); 
        print("<tr><td style='text-align:right'><input type='radio' name='rating' value='3'></td><td><img src='images/3_s.gif' alt='3 stars'> Average</td></tr>\n"); 
        print("<tr><td style='text-align:right'><input type='radio' name='rating' value='4'></td><td><img src='images/4_s.gif' alt='4 stars'> </td></tr>\n"); 
        print("<tr><td style='text-align:right'><input type='radio' name='rating' value='5'></td><td><img src='images/5_s.gif' alt='5 stars'> Excellent</td></tr>\n"); 
        print("<tr><td colspan='2' style='text-align:center'><input name='submit' type='submit' value='Rate Song' ></td></tr>\n"); 
        print("</table></form>\n"); 
    } 

} 

[Rodney_H_]

If I understand you correctly, the form shouldn't be popping open a new window because the target attribute in the opening form tag hasn't been stipulated. Therefore the window that the form is filled out in should be the same window that processes/handles the form.

If you want a new window, you can change the target as in the following example:

<form action="action.php" method="post" target="_blank">

If there is more information on the page that handles/processes the form than you wish, just remove the offending code from that page... Does that make sense??

[DoMiNaToR69]

thanx that helped me a lot