Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: updating fields

  1. #1
    Senior Coder Nightfire's Avatar
    Join Date
    Jun 2002
    Posts
    4,265
    Thanks
    6
    Thanked 48 Times in 48 Posts

    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

  • #2
    Senior Coder Nightfire's Avatar
    Join Date
    Jun 2002
    Posts
    4,265
    Thanks
    6
    Thanked 48 Times in 48 Posts
    Nevermind, realised what I did wrong Forgot to update the page which shows the results

    Today isn't my day for coding

  • #3
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    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?
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #4
    Senior Coder Nightfire's Avatar
    Join Date
    Jun 2002
    Posts
    4,265
    Thanks
    6
    Thanked 48 Times in 48 Posts
    LOL I forgot to upload the results page. Doesn't matter anymore, it works


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •