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 <[email protected]> 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]
>
>