Sorted :)
Best Regards,
Gavin Chalkley
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@xxxxxxxxx>
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
|