[SOLVED] Unknown column error

[Henaro]

Hello everyone~

 

I seem to have stumbled onto a terrible error today! 

 

It reads "Unknown column 'rname' in 'field list'".  I googled it and I found that I needed apostrophes on my statements.  But that doesn't seem to be working.  Here is my statement:

 

UPDATE boards SET rname='$r' WHERE number='$number'

 

And the table:

CREATE TABLE `boards` (
  `number` int(3) NOT NULL auto_increment,
  `name` text NOT NULL,
  `rnames` int(1) NOT NULL default '2',
  `Description` text NOT NULL,
  `open` int(11) NOT NULL default '1',
  PRIMARY KEY  (`number`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

MYSQL version is 5.  I'm trying to change rname to what the user inputs.  Any suggestions? 

[beebum]

Your table has "rnames" plural and your command has "rname" singular.

[Henaro]

Oh wow... this is embarrassing.