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! Link to comment https://forums.phpfreaks.com/topic/250598-trouble-with-update/ 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'"; ?> Link to comment https://forums.phpfreaks.com/topic/250598-trouble-with-update/#findComment-1285768 Share on other sites More sharing options...
melting_dog Posted November 7, 2011 Author Share Posted November 7, 2011 Brilliant! Thanks Link to comment https://forums.phpfreaks.com/topic/250598-trouble-with-update/#findComment-1285772 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.