php UPDATE

[a1amattyj]

Hello,

 

Just ran into another issue:

 

 

php :

 

$update = "UPDATE {$db_prfix}setting SET value = '1' WHERE variable = restatecost";
$result = MYSQL_QUERY($update) or die(mysql_error());

 

Table:

 

CREATE TABLE `setting` (

  `variable` longtext NOT NULL,

  `description` longtext NOT NULL,

  `value` longtext NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `setting` VALUES('restatecost', 'How much does a house cost?', '200000');

 

Error: Unknown column 'restatecost' in 'where clause'

 

any ideas?

 

Ta

[BlueSkyIS]

$update = "UPDATE {$db_prfix}setting SET value = '1' WHERE variable = 'restatecost'";