Re: Function assistance

Hi Suman,

Yes the variables are containing data. vcode is randomly generated, 
loginName, and email come in from a form.

I have used var_dump, and also print on the variables, and data is there.

Best Regards,

Gavin Chalkley


MSTC WES7


On 09/04/2012 17:14, madavapeddi suman wrote:
> 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] 
> <mailto:[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
>
>
>     MSTC WES7
>
>