Function assistance

Gavin <gavin.chalkley@xxxxxxxxx> · Mon, 09 Apr 2012 16:44:07 +0100



    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