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. Link to comment https://forums.phpfreaks.com/topic/251439-update-query-not-working-can-u-help/ 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? Link to comment https://forums.phpfreaks.com/topic/251439-update-query-not-working-can-u-help/#findComment-1289566 Share on other sites More sharing options...
fenway Posted November 19, 2011 Share Posted November 19, 2011 MySQL tells you why it fails. Link to comment https://forums.phpfreaks.com/topic/251439-update-query-not-working-can-u-help/#findComment-1289601 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.