Jump to content


Photo

simple UPDATE syntax propblem


  • Please log in to reply
2 replies to this topic

#1 fireman

fireman
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 16 December 2003 - 12:59 AM

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
Fireman-- [br] [br]if this code stuff was on fire--I\'d KNOW what to do next!!

#2 nabeel21

nabeel21
  • Members
  • PipPip
  • Member
  • 25 posts

Posted 16 December 2003 - 01:04 AM

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

#3 fireman

fireman
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 16 December 2003 - 06:01 AM

strange but true--that did the trick nabeel.

I thank you!!
Fireman-- [br] [br]if this code stuff was on fire--I\'d KNOW what to do next!!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users