mystery mysql error
I'm by no means experienced in mysql and keep getting an error in this lines of code:  

    $sql= "INSERT INTO songs (unique_show_id, artist, date, year, city, state, venue, taper, transfered_by, source, mic_loc, lineage, uploaded_by, uploaded_on, show_notes, show_xml)
				VALUES('$showId', '$artist', '$showDate', '$year, '$city', '$state', '$venue', '$taper', '$transferer', '$source', '$mic_loc', '$lineage', '$uploader', NOW(), '$show_notes', '$show_xml')";    
    			
    //check to see if the query went through
				if (!mysql_query($sql,$con)){
				  echo "query fail";
  				die('Error: ' . mysql_error());
        }
        

  
I'm sure it's something simplistic, but I can't see where the error is. The error message I get is:  

    query failError: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ipuhgbi', 'CA', '', '', '', '', '', '', 'danwoods', NOW(), '', '<show id=\'gm198' at line 2  


Some of the values I'm inserting are NULL, but from what I've read I don't think that should be a problem. Any ideas?

mystery mysql error
===

I'm by no means experienced in mysql and keep getting an error in this lines of code:  

    $sql= "INSERT INTO songs (unique_show_id, artist, date, year, city, state, venue, taper, transfered_by, source, mic_loc, lineage, uploaded_by, uploaded_on, show_notes, show_xml)
				VALUES('$showId', '$artist', '$showDate', '$year, '$city', '$state', '$venue', '$taper', '$transferer', '$source', '$mic_loc', '$lineage', '$uploader', NOW(), '$show_notes', '$show_xml')";    
    			
    //check to see if the query went through
				if (!mysql_query($sql,$con)){
				  echo "query fail";
  				die('Error: ' . mysql_error());
        }
        

  
I'm sure it's something simplistic, but I can't see where the error is. The error message I get is:  

    query failError: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ipuhgbi', 'CA', '', '', '', '', '', '', 'danwoods', NOW(), '', '<show id=\'gm198' at line 2  


Some of the values I'm inserting are NULL, but from what I've read I don't think that should be a problem. Any ideas?
