Skip navigation links

MySQL Forums :: Perl :: MySql, Perl, and HTML Update function not working


Advanced Search

MySql, Perl, and HTML Update function not working
Posted by: adam gruber ()
Date: January 31, 2013 03:59PM

Hello,
I used a guide that I found that was written by Tony Darnell regarding using MySql, Perl, and a little HTML to create, update, and delete database records. Everything works perfectly, except for the UPDATE functionality. Is there anything explicitly wrong with the following lines

$serial = $formdata{'serial'};
$name_first = $formdata{'name_first'};
$name_last = $formdata{'name_last'};
$address_01 = $formdata{'address_01'};
$address_02 = $formdata{'address_02'};
$address_city = $formdata{'address_city'};
$address_state = $formdata{'address_state'};
$address_postal_code = $formdata{'address_postal_code'};

$dbh = ConnectToMySql($Database);

$query = "update address set name_first = '$name_first', name_last = '$name_last', address_01 = '$address_01', address_02', address_city = '$address_city', address_state = '$address_state', address_postal_code = '$address_postal_code' where serial = '$serial'";

$sth = $dbh->prepare($query);

$sth->execute();

$dbh->disconnect;


When I takek out the $serial and enter in a manual value in the $query line, it works. So something is not kosher with having it grab that value on its own. I am a complete MySql and Perl n00b btw, so I apologize right off the bat if i misunderstand something or am missing something easy. Thanks for the help and let me know if you need any other info.

Options: ReplyQuote


Subject Written By Posted
MySql, Perl, and HTML Update function not working adam gruber 01/31/2013 03:59PM
Re: MySql, Perl, and HTML Update function not working Randy Clamons 01/31/2013 04:39PM
Re: MySql, Perl, and HTML Update function not working adam gruber 02/01/2013 09:08AM
Re: MySql, Perl, and HTML Update function not working Rick James 02/03/2013 10:52AM
Re: MySql, Perl, and HTML Update function not working adam gruber 02/03/2013 11:11AM
Re: MySql, Perl, and HTML Update function not working Rick James 02/03/2013 03:01PM
Re: MySql, Perl, and HTML Update function not working adam gruber 02/05/2013 08:51AM


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.