updating fields
 

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

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

Today isn't my day for coding

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?

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