mysqp เชื่อม id 2 ตารางยังไงเหรอคับ มันฟ้องว่า Field 'id_member' doesn't have a default value

<form method="post" action="add_album.php" >
  <fieldset>
    <legend>สร้างอัลบั้ม</legend>
    <p>ชื่ออัลบั้ม 
      <input name="album_name" type="text" id="album_name" />
    </p>
    <p>
      <input name="" type="submit" value="Submit" />
    </p>
 
    
  </fieldset>
</form>

<?
	mysql_connect("localhost","root","root");
	mysql_select_db("project");
	
	if(trim($_POST["album_name"]) == "")
	{
		echo "Please Album Name !";		
		echo "<meta http-equiv=refresh content=2;URL=http://localhost/mdz/action/user_main.php?album_name=".$_POST["album_name"].">";
		exit();	
	}
	
	$strSQL = "SELECT * FROM album WHERE album_name = '".trim($_POST['album_name'])."' ";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	if($objResult)
	{
			echo "Album name already exists!";
			echo "<meta http-equiv=refresh content=2;URL=http://localhost/mdz/action/user_main.php>";
	}
	else
	{	
		
		$strSQL = "INSERT INTO album (album_name) VALUES ('".$_POST["album_name"]."')";
		$objQuery = mysql_query($strSQL) or die(mysql_error());
		
		echo "Register Completed!<br>";		
		echo "<meta http-equiv=refresh content=3;URL=http://localhost/mdz/action/user_main.php>";
		
	}

	mysql_close();
?>