Re: Function assistance

The starngest part is it works absolutly fine on XAMPP setup 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 <gavin.chalkley@gmail.com <mailto: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

    MSTC WES7