Re: Function assistance

hi, Trying seeing whether $vcode ,$loginName and $email variables contains the values? /Suman On Mon, Apr 9, 2012 at 11:44 AM, Gavin <gavin.chalkley@gmail.com> wrote: > All, > > I am having a small issue which is making me bang my head against a wall. > > I am running XAMMP with PHP 5.4 installed and this worked before uploading > to my live dev site. > > The part of the function that doesn't seem to be working is : > > $pdo = $this->connection(); > $sql = "UPDATE memeber SET > vcode=:vcode WHERE > loginName=:loginName and > email=:email"; > $q = $pdo->prepare($sql); > $q->execute(array(':vcode' => $vcode, ':loginName' => > $loginName, > ':email' => $email)); > > I have tried the SQL statement direct into PHPMyAdmin, replacing the :name > holders with true data, and it worked. > > But trying the above script fails to update. Am i missing something > completely here? > -- > > Best Regards, > > Gavin Chalkley > > [image: MSTC WES7] > >