melting_dog Posted November 7, 2011 Share Posted November 7, 2011 Hi guys, Sorry - this might more belong in the SQL section but I think it is PHP related. I am trying to update a table with: $sql="UPDATE $tbl_name SET (gender, description) VALUES ('$gender', '$description') WHERE image = ('$photoname')"; $result=mysql_query($sql); Needless to say, its not working. Only odd thing is that the $photoname variable is sent with a hidden field on the previous form. I can echo all 3 varaibles though and get the right results. I just dont know why it isnt updating - seems pretty standard to me. Can anyone help? Thanks! Quote Link to comment Share on other sites More sharing options...
watsmyname Posted November 7, 2011 Share Posted November 7, 2011 <?php $sql="UPDATE $tbl_name SET gender='$gender',description='$description' WHERE image = '$photoname'"; ?> Quote Link to comment Share on other sites More sharing options...
melting_dog Posted November 7, 2011 Author Share Posted November 7, 2011 Brilliant! Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.