in the following piece of code the else part of my if/else statements doent seem to work it just adds nothing, thanks.
btw genre is a dropbox (and yes i have added the values) and genre2 is a text box, same with the filehost and filehost2.
$name = $_POST['song'];
$artist = $_POST['artist'];
$genre = $_POST['genre'];
$genre2 = $_POST['genre2'];
$filehost = $_POST['filehost'];
$filehost2 = $_POST['filehost2'];
$link = $_POST['link'];
if($genre="other")
{$genre=$genre2;}
else{$genre=$genre;}
if($filehost="other")
{$filehost=$filehost;}
else{$filehost=$filehost;}
$con = mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$sql = "INSERT INTO `songs` VALUES ('','$name','$artist','$genre','$filehost','$link')";
$query = mysql_query($sql) or die('Error: ' . mysql_error());