shadiadiph Posted December 18, 2008 Share Posted December 18, 2008 I have a form that submits to an update page. When I submit it acts as if nothing is wrong and redirects to the correct page but it isn't up dating the database does abosubtely nothing and displays no error messages.?? <? session_start(); error_reporting(7); require("../global/admin_functions.php"); $accountid = ($_POST["accountid"]); $username = ($_POST["username"]); $email = ($_POST["email"]); $company = ($_POST["company"]); $position = ($_POST["position"]); $firstname = ($_POST["firstname"]); $lastname = ($_POST["lastname"]); $street = ($_POST["street"]); $city = ($_POST["city"]); $state = ($_POST["state"]); $postal = ($_POST["postal"]); $country = ($_POST["country"]); $insertsql = "update tbluserdetails set email='.$email.', company='$company', position='$position', firstname='$firstname', lastname='$lastname', street='$street', city='$city', state='$state', postal='$postal', country='$country', dtupdated='(now()' where intAccountID='$accountid'"; $DB_site->query($insertsql); header("Location:myprofile.php?accountid='$sid'"); exit; ?> Link to comment https://forums.phpfreaks.com/topic/137511-update-sql-script-fuctioning-but-not-working/ Share on other sites More sharing options...
RussellReal Posted December 18, 2008 Share Posted December 18, 2008 dtupdated='(now()' also, you should get into the habbit of forming well formed strings and practice good syntax. for instance UPDATE `tableName` etc etc and '{$var}' instead of '$var' just {$var} in any case Link to comment https://forums.phpfreaks.com/topic/137511-update-sql-script-fuctioning-but-not-working/#findComment-718600 Share on other sites More sharing options...
shadiadiph Posted December 18, 2008 Author Share Posted December 18, 2008 thanks i didn't see that but that wasn't the problem but it would have been the next one. The problem was it wasn't writing to the database because i forgot to carry over accountid as a hidden form value on the previous page. Link to comment https://forums.phpfreaks.com/topic/137511-update-sql-script-fuctioning-but-not-working/#findComment-718640 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.