Here is my code
Quote:
$query = "SELECT * FROM playlist WHERE username = '".$session->username."' ORDER BY playlist_name ASC";
$result = mysql_query($query) or die(mysql_error());
if( mysql_num_rows($result)>0 ) {
$delplaylist = "DELETE";
print("<form name='form' action='$delplaylist' method='post'>\n");
print("<table style='width: 100%; border: 0px;'>\n");
print("<tr><td colspan='2'><font color='#0000FF'size='2' face='Verdana, Arial, Helvetica, sans-serif'><u>Borrar listas de musica:</u></font></td></tr>\n");
print("<tr><td><font size='2' color='#0000FF' face='Verdana, Arial, Helvetica, sans-serif'>Lista(s) de musica:</font></td><td><select name='playlist_id'>");
while( $playlist = mysql_fetch_assoc($result) )
{
$deleteplaylist = print("<option value='".$playlist['id']."'>".$playlist['playlist_name']."</option>\n");
echo $deleteplaylist;
}
print("</select></td></tr>\n");
print("<tr><td colspan='2' style='text-align:center'><input name='submit' type='submit' value='Borrar Lista' ></td></tr>\n");
print("</table></form>\n");
}
|
This is pretty much a music site where the user can create playlists. Here I'm trying to let the user erase the selected playlist the user chooses after the submit button is pressed. So far i have this code. Any help on doing that?