View Full Version : updating fields

09-11-2002, 01:39 AM
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

09-11-2002, 02:32 AM
Nevermind, realised what I did wrong :o Forgot to update the page which shows the results

Today isn't my day for coding

09-11-2002, 02:32 AM
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?

09-11-2002, 03:24 AM
LOL I forgot to upload the results page. Doesn't matter anymore, it works :)