[php][mysql] UPDATE function

[taekwondokid42]

mysql_query("UPDATE wiki_quotes SET Quote = '$Quote' WHERE id = \"$counter\"");


That line of code is a working line of code.

I need to set a column named Submitted By equal to another variable.

If I try...

...SET 'Submitted By' it gives me an error becuase of the 's

...SET Submitted By it gives me an error becuase of the space

...SET \"Submitted By\" it gives me an error because of the quotes.



Does anyone have any other suggestions?

 

[Bryon]

("UPDATE `wiki_quotes` SET `Quote` = '$Quote', `Submitted By` = '$submittedBy' WHERE `id` = '$counter'");

 

[taekwondokid42]

I'm not quite sure why that worked, but thank you.

 

[Adam01]

You can use ` aswell as '.