PHP Version 5.2.3, Windows 2000 IIS Server
Here is the table structure from SHOW COLUMNS FROM input:
Array ( [0] => stdClass Object ( [Field] => id [Type] => int(10) [Null] => [Key] => PRI [Default] => [Extra] => auto_increment ) [1] => stdClass Object ( [Field] => number [Type] => varchar(10) [Null] => YES [Key] => [Default] => [Extra] => ) [2] => stdClass Object ( [Field] => temp_reviewer [Type] => varchar(50) [Null] => YES [Key] => [Default] => [Extra] => ) [3] => stdClass Object ( [Field] => doc_review_id [Type] => int(10) [Null] => [Key] => [Default] => 0 [Extra] => ) [4] => stdClass Object ( [Field] => title_of_doc [Type] => varchar(255) [Null] => [Key] => MUL [Default] => [Extra] => ) [5] => stdClass Object ( [Field] => reviewer [Type] => varchar(25) [Null] => [Key] => MUL [Default] => [Extra] => ) [6] => stdClass Object ( [Field] => original_reviewer [Type] => varchar(10) [Null] => YES [Key] => [Default] => [Extra] => ) [7] => stdClass Object ( [Field] => office [Type] => varchar(255) [Null] => [Key] => [Default] => [Extra] => ) [8] => stdClass Object ( [Field] => category [Type] => int(1) [Null] => [Key] => [Default] => 0 [Extra] => ) [9] => stdClass Object ( [Field] => status [Type] => int(1) [Null] => YES [Key] => [Default] => 0 [Extra] => ) [10] => stdClass Object ( [Field] => line_num [Type] => varchar(50) [Null] => YES [Key] => MUL [Default] => [Extra] => ) [11] => stdClass Object ( [Field] => page [Type] => varchar(50) [Null] => YES [Key] => [Default] => [Extra] => ) [12] => stdClass Object ( [Field] => section [Type] => varchar(255) [Null] => YES [Key] => [Default] => [Extra] => ) [13] => stdClass Object ( [Field] => paragraph [Type] => varchar(255) [Null] => YES [Key] => MUL [Default] => [Extra] => ) [14] => stdClass Object ( [Field] => remark [Type] => mediumtext [Null] => [Key] => MUL [Default] => [Extra] => ) [15] => stdClass Object ( [Field] => disposition [Type] => longtext [Null] => YES [Key] => MUL [Default] => [Extra] => ) [16] => stdClass Object ( [Field] => contractor_response [Type] => longtext [Null] => YES [Key] => [Default] => [Extra] => ) [17] => stdClass Object ( [Field] => latest_reviewer [Type] => varchar(50) [Null] => [Key] => [Default] => [Extra] => ) [18] => stdClass Object ( [Field] => timestamp [Type] => varchar(20) [Null] => [Key] => MUL [Default] => [Extra] => ) [19] => stdClass Object ( [Field] => vendor_response [Type] => longtext [Null] => YES [Key] => MUL [Default] => [Extra] => ) [20] => stdClass Object ( [Field] => modified [Type] => tinyint(1) [Null] => [Key] => [Default] => 0 [Extra] => ) [21] => stdClass Object ( [Field] => final_review [Type] => tinyint(1) [Null] => [Key] => [Default] => 0 [Extra] => ) ) id
number
temp_reviewer
doc_review_id
title_of_doc
reviewer
original_reviewer
office
category
status
line_num
page
section
paragraph
remark
disposition
contractor_response
latest_reviewer
timestamp
vendor_response
modified
final_review
$query = "UPDATE input SET doc_review_id = '$doc_review_id', reviewer = '$reviewer', category = '$category', status = '$status', line_num = '$line_num', page = '$page', section = '$section', paragraph = '$paragraph', remark = '$remark', latest_reviewer = '$latest_reviewer', severity = '$severity', modified = '0' WHERE id = '$id'";
mysql_query($query) or die(mysql_error());
Unknown column 'severity' in 'field list'
If I keep refreshing that page, it eventually updates. Why do I keep getting "Unknown column 'severity' in 'field list'"?
