ansaurus

Question

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

Answer 1

+1 A:

Most likely, there is a typo, either in the field list, or in the name of the column in the database. Or, hopefully somewhat less likely, the column actually doesn't exist.

Double check your database table.

However, while unlikely, it does appear that there has been a related bug reported here (http://bugs.mysql.com/bug.php?id=1689) for MySQL version 4.0.16 I doubt that this affects you, but it may be worth looking into.

jordanstephens 2010-09-30 17:37:05

Thanks, you are correct. I overlooked the spelling of rec_label I had it spelled rec_lable. Sorry for the bother, but thank you so much for your help

William Grider 2010-09-30 17:40:09

Answer 2

+1 A:

Please. Use mysqli and prepared statements.

<?
if ((!$_POST['id']) || (!$_POST['format']) || (!$_POST['title'])) {
  header ("Location: /show_addrecord.html");
  exit;
}

$db_name = "testdb2";
$table_name = "my_music";
$connection = @mysqli_connect("localhost", "spike", "9sj7En4") or die (mysqli_error());
$db = @mysqli_select_db($connection, $db_name) or die(mysqli_error());

// BTW, using $tablename here is also wrong on several levels. Avoid.
$sql = "
  INSERT INTO $table_name
  (id, format, title, artist_fn, artist_ln, rec_label, my_notes, date_acq) VALUES
  (?,?,?,?,?,?,?,?)
";

$stmt = mysqli_prepare($connection, $sql);

mysqli_stmt_bind_param($stmt, "ssssssss", 
  $_POST['id'],
  $_POST['format'],
  $_POST['title']),
  $_POST['artist_fn'],
  $_POST['artist_ln'],
  $_POST['rec_label']),
  $_POST['my_notes'],
  $_POST['date_acq']
);

$result = @mysqli_stmt_execute($connection, $sql) or die(mysqli_error());

mysqli_stmt_close($stmt);

?>

Tomalak 2010-09-30 17:38:32

ansaurus

tags:

views:

answers:

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

related questions