Jump to content

update sql script fuctioning but not working


shadiadiph

Recommended Posts

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;

?>

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.