Flyer5 Posted November 19, 2011 Share Posted November 19, 2011 Can anyone tell me why this fails? Value is passed from a form, and printing all the variabls shows they are correctly passed. ----------------------------------------------- if(isset($_POST['update'])) (connection to database is here) $house_number = $_POST['house_number']; $query = "UPDATE asw_users (house_number) VALUES ('$house_number') WHERE username='".$_SESSION['username']."' "; mysql_query($query) or die('Error, updating query During update proc failed'); ------------------------------------------------------------ it looks simple enough but i cant get it to update the db any ideas? ta. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted November 19, 2011 Share Posted November 19, 2011 What happens when you execute the query? Error, or nothing at all? Quote Link to comment Share on other sites More sharing options...
fenway Posted November 19, 2011 Share Posted November 19, 2011 MySQL tells you why it fails. 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.