I keep getting this - Unknown column 'rec_label' in 'field list'

vattsluth · Sep 14, 2012

here is my code\[code\]<?if ((!$_POST['id']) || (!$_POST['format']) || (!$_POST['title'])) {header ("Location: /show_addrecord.html");exit;}$db_name = "testdb2";$table_name = "my_music";$connection = @mysql_connect ("localhost", "spike", "9sj7En4")or die (mysql_error());$db = @mysql_select_db ($db_name, $connection) or die(mysql_error());//create SQL statement and issue query$id = mysql_escape_string($_POST['id']);$format = mysql_escape_string($_POST['format']);$title = mysql_escape_string($_POST['title']); $artist_fn = mysql_escape_string($_POST['artist_fn']);$artist_ln = mysql_escape_string($_POST['artist_ln']);$rec_label = mysql_escape_string($_POST['rec_label']);$my_notes = mysql_escape_string($_POST['my_notes']);$date_acq = mysql_escape_string($_POST['date_acq']);$sql = "INSERT INTO $table_name(id, format, title, artist_fn, artist_ln, rec_label, my_notes, date_acq) VALUES('$_POST[id]','$_POST[format]','$_POST[title]','$_POST[rec_label]', '$_POST[artist_fn]','$_POST[artist_ln]','$_POST[my_notes]','$_POST[date_acq]')";$result = @mysql_query($sql, $connection) or die(mysql_error());?><html><head><title>Add a Record</title></head><body><table cellspacing=3 cellpadding=3><tr><td valign=top>ID: <? echo "$_POST[id]"; ?></td><td>Date Acquired (YYYY-MM-DD): <? echo "$_POST[date_acq]"; ?></td><td valign=top>Format: <? echo "$_POST[format]"; ?></td></tr><tr><td valign=top>Title: <? echo "$_POST[title]"; ?></td><td valign=top>Record Label <? echo "$_POST[rec_label]"; ?></td></tr><td valign=top>Artist's First Name: <? echo "$_POST[artist_fn]"; ?></td><td valign=top>Artist's Last Name: <? echo "$_POST[artist_ln]"; ?></td></tr><tr><td valign=top colspan=2 align=center>My Notes: <? echo stripslashes($_POST[my_notes]); ?><a href="http://stackoverflow.com/questions/3833185/show_addrecord.html">Add Another</a></td></tr></table></body></html>\[/code\]

I keep getting this - Unknown column 'rec_label' in 'field list'

vattsluth

New Member