MySQL Forums
Forum List  »  Perl

Re: update not work in perl programming
Posted by: Felix Geerinckx
Date: May 10, 2005 03:43AM

arupratan biswas wrote:

> nothing but when i put the value then it could not updated,i cant understand what happen.
> u just see the code then understand what actually happen?

I have no time to check your code in detail, but change these lines:

> $sth=$dbh->prepare("Update new_user SET
> emp_name='$ename',emp_add='$eadd',password='$pword',city='$ct',
> zip_code='$zcode',dob='$d',phone='$ph',photo='$pto' > where emp_name=?");
> $sth->execute($toname);

into:

$sql = "Update new_user SET
emp_name='$ename',emp_add='$eadd',password='$pword',city='$ct',
zip_code='$zcode',dob='$d',phone='$ph',photo='$pto' > where emp_name=?";
print STDERR "sql = $sql with ? = '$toname'\n";
$sth=$dbh->prepare($sql);
$sth->execute($toname);

and check the your sql statement in the error log of your webserver.

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
Re: update not work in perl programming
May 10, 2005 03:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.