updating fields

[Nightfire]

How can I update various fields at once? I tried

UPDATE members SET bio='$bio',chat='$chat' WHERE username='$username'"

but it doesn't seem to update the chat field for some reason

I'm using php

[Nightfire]

Nevermind, realised what I did wrong :o Forgot to update the page which shows the results

Today isn't my day for coding

[Spookster]

Well from what you posted there is nothing wrong with your SQL statement.

Are you sure that $chat actually has a value? Have you tried echoing it out to the document?

[Nightfire]

LOL I forgot to upload the results page. Doesn't matter anymore, it works :)