🚀 go-pugleaf

I have a simple interface where a user can click on a students name which is a link to the next page, a details page if you will. A page parameter is passed to fill the next page with the information pulled from the db table with the corresponding primary key in this case the student's ID.

This information is inside a form with only a hidden field named "vote" and a value of // '<?php echo pageParameter("showme",""); ?>' The showme contains the primary key so that when the submit button is pressed the students's ID is posted.

The form action is linked to the next page which is a simple thank you for voting. It also contains some php script.
// <?php $vote = $_POST['vote']; //		$query = "update tbaotw set atw_votes = atw_votes + 1 where atw_ID = '$vote' "; //		?>

I know the ID is being posted because I can use the echo command to display the current ID that was passed. The script executes but the db isn't updated. The query works with in phpMyAdmin but not in GoLive.

Am I doing something wrong. Do I have to create a select statement to retrieve the value for atw_votes and then add 1 to it. then add it to the db.

Any help would be appreciated. Thanks