simple UPDATE syntax propblem

[fireman]

ok, I know this is basic, but what can i say, I\'m a fireman.

 

I want to UPDATE a row based upon input from a user. what is wrong with the following code?

$query = ("UPDATE votes SET prop=\'$prop\', month=\'$month\', day=\'$day\', year=\'$year\', desc=\'$desc\', vote=\'$vote\' WHERE id=\'$id\'");

 

That\'s it, simple huh?

 

Any help would be most appreciated

[nabeel21]

I think this desc column is causing a problem. I remember having this kind of problem but when i changed the column name to something else... it worked.

 

Please give it a try.

 

goodluck

[fireman]

strange but true--that did the trick nabeel.

 

I thank you!!