Re: Function assistance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Could it have come down to a simple typo.  Checking the table name, do you have a table with the name "memeber" or "member"?

On 10 April 2012 02:20, Gavin <gavin.chalkley@xxxxxxxxx> wrote:
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


On 09/04/2012 17:14, madavapeddi suman wrote:
  Trying seeing whether $vcode ,$loginName and $email variables contains the values?

On Mon, Apr 9, 2012 at 11:44 AM, Gavin <gavin.chalkley@xxxxxxxxx> wrote:

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


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux