Re: Function assistance

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@gmail.com> 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 > > [image: 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> 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 >> >> [image: MSTC WES7] >> >> >